Answer to please help

[kss444]

Sql server 2000 can not see
sql server 2005 or express.
You need to download this.

http://www.microsoft.com/downloads/...ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en

Microsoft SQL Server Management Studio Express tool
with this you can see 2005 and 2000.
Very cool tool better that 2000 tools.

 

[SQLDenis]

I use Microsoft SQL Server Management Studio...much better than Microsoft SQL Server Management Studio Express tool


and BTW Query Analyzer (2000) CAN see SQl server 2005

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[Elroacho]

Hi,

I have been using Microsoft SQL Server Management Studio Express. This was working fine with the database untill I created a data source connection in Visual Studio.

Doing this seemd to change the connection string that was required. This was fine for the VS application I am developing, I just changed the SQLConnection string to what was required. However I can't seem to do that with Microsoft SQL Server Management Studio Express or TOAD.

the old connection string was something like this:

Server="(local)"; Trusted_Connection="yes";  Database="CDEvolution";

When I could use this all was fine. Both the application and the DB tools could connect.

now I have to use this string:

Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL\Data\CDEvolution.mdf;Integrated Security=True;Connect Timeout=6000;User Instance=True;

This is no problem for the application I have developed as I can change the string and it works well, however I can't connect using the DB tools and I can't see where or how I change the way the db tools connect to the database.

Cheers,
Kevin.