473,386 Members | 1,908 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

can't see my databases

hey all,
i'm using vs2005 and i'm under server explorer. i'm just trying to add a new
connection to .\sqlexpress (sql express 2005) using sql server authentication
but when i goto select the database in the dropdownlist there are 0 entries
in the list.

what i've done so far is Enabled the sa profile. what else might i be missing?

thanks,
rodchar
Apr 5 '07 #1
3 1015
Hello rodchar,

Connect to server with the SQL management studio and check that these databases
exist

---
WBR, Michael Nemtsev [C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

rhey all,
ri'm using vs2005 and i'm under server explorer. i'm just trying to
radd a new
rconnection to .\sqlexpress (sql express 2005) using sql server
rauthentication
rbut when i goto select the database in the dropdownlist there are 0
rentries
rin the list.
rwhat i've done so far is Enabled the sa profile. what else might i be
rmissing?
r>
rthanks,
rrodchar
Apr 5 '07 #2
Did you configure the 'SQL surface area configuration' to enable connection
to SQL?
If so, try to connect to "localhost\sqlexpress".
greetz,

--
LadyRoot
----------------------------
no place like 127.0.0.1
live : lady_root(a)msn.com
Użytkownik "rodchar" <ro*****@discussions.microsoft.comnapisał w
wiadomo¶ci news:97**********************************@microsof t.com...
hey all,
i'm using vs2005 and i'm under server explorer. i'm just trying to add a
new
connection to .\sqlexpress (sql express 2005) using sql server
authentication
but when i goto select the database in the dropdownlist there are 0
entries
in the list.

what i've done so far is Enabled the sa profile. what else might i be
missing?

thanks,
rodchar
Apr 5 '07 #3
Under Database Engine/Remote Connections I select Using both TCP/IP and named
pipes, restarted sql server service, but that didn't seem to work. unless i
have to shut down visual studio and reopen i haven't tried that yet.

"LadyRoot" wrote:
Did you configure the 'SQL surface area configuration' to enable connection
to SQL?
If so, try to connect to "localhost\sqlexpress".
greetz,

--
LadyRoot
----------------------------
no place like 127.0.0.1
live : lady_root(a)msn.com
UĆŒytkownik "rodchar" <ro*****@discussions.microsoft.comnapisaƂ w
wiadomoƛci news:97**********************************@microsof t.com...
hey all,
i'm using vs2005 and i'm under server explorer. i'm just trying to add a
new
connection to .\sqlexpress (sql express 2005) using sql server
authentication
but when i goto select the database in the dropdownlist there are 0
entries
in the list.

what i've done so far is Enabled the sa profile. what else might i be
missing?

thanks,
rodchar

Apr 5 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Gary L. Burnore | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.mysql This is an invitation to discuss the following proposal to create newsgroup comp.databases.mysql. Please note that YOU CANNOT...
8
by: William Drew | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.mysql This is an invitation to discuss the following proposal to create newsgroup comp.databases.mysql. Please note that YOU...
0
by: Mark Townsend | last post by:
Following is a summary of articles spanning a 7 day period, beginning at 23 Feb 2004 05:29:19 GMT and ending at 01 Mar 2004 04:12:14 GMT. Notes ===== - A line in the body of a post is...
1
by: phpbird | last post by:
please give me a mail.3q
0
by: Fred Johnson | last post by:
Hi folks: I need to give a special user admin rights to the databases he creates. As there is no dedicated MySQL database server for his needs yet, we created a special user on a...
3
by: jimstallings | last post by:
Hi, I am trying to locate documentation on using views across databases. We have serveral databases broken down by application, some shared databases and some location specific databases...
10
by: Rada Chirkova | last post by:
Hi, at NC State University, my students and I are working on a project called "self-organizing databases," please see description below. I would like to use an open-source database system for...
3
by: Amit | last post by:
Hi when I try to run LIST ACTIVE DATABASES AT DBPARTITIONNUM <partnum> or LIST ACTIVE DATABASES GLOBAL, I always get an error message. Does anyone know why? I'm on v8 fp 5 output : db2 => list...
6
by: Andy | last post by:
Someone posted this official proposal to create comp.databases.postgresql.general again. He wrote his own charter. As far as I know, he did not consult any of the postgresql groups first. There...
1
by: judy | last post by:
I have several databases that are used to collect data for different client-projects. My intention was to collect the data, and administer mySQL so each client could see only their data. Each of...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.