Connecting to Northwind on SQL Server 2000

I've just installed SQL Server 2000 on my local machine. I'm using the following element in my web.config file for my connection string.

<add key="SqlNWind512" value="server=(local)\141.705.84.745;database=Northwind;
user id=sa;pwd=h3fe8eq7;packet size=512;" /
Unfortunately, I'm getting the following error on my aspx page:

SQL Server does not exist or access denied.

I had no problem writing a connection string to connect to the MSDE installed on my computer, but making a connection to the Northwind database on my newly installed SQL Server 2000 Developer edition has been elusive to me.

I'm sure my IP address is correct. The authentication mode for logging into the database via Enterprise Manager is setup to require a password for sa. Therefore, I assume it's required in the connection string?

Maybe not so coincidentally, while I have been able to open this database through the Server Explorer in VS.NET, I'm not able to access it via Enterprise Mananger (no response, it just hangs) or my aspx pages.

I'm dying here!!! Is my connection string wrong? Any insights would be greatly appreciated!just server=<ip address
forget the (local) bit if it's not local.|||Thank you!|||word to the wise..
Don't put your password to your database online on forums.

h3fe8eq7 can be a very bad thing.

Connecting to Northwind

On the 3rd page of the Tutorial 1, there is a section Connecting to the Database in a Microsoft SQL Server 2000 or 2005 Database Server. It instructs you to connect to the Northwind database in the C:\DataTutorial\App_Data directory. I have Northwind.mdf showing up in my Server Explorer and it is 3.7 mb in size in the directory, but the Server Explorer shows it with a - sign beside it and I cannot figure any way to get access to the tables, views, etc. I have read and re-read everything I can find on this and I know I am missing something simple, but I am stumped. Can anyone offer some help? Thanks, Ron

Do you have the Northwind database server-attached to your running srver, or did you setup the database as a user instance in your server explorer ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Jens,

It appears that Visual Studio solved the problem. When I opened my project today, the Northwnd.mdf database showed up fully populated in the Server Explorer window.

If you have any clue as to what I could have done yesterday to not properly permit the database to show, I would love to know so I don't do it again. I don't know if I had my "database server-attached to your running srver, or did you setup the database as a user instance in your server explorer ?" All I did was put the file in northwnd.mdf file into the c:\DataTutorial\App_Data\ directory. When it didn't show up, I also executed the instwnd.sql file with debug turned off, but, at least yesterday, that didn't seem to help.

Thanks again,

Ron Hall

sqlsql

connect to sql server 2005 express from coldfusion mx 7

webacadie hit the nail on the head.Thanks a bunch.Finally I got coldfusion administrator to talk to Northwind database in sql server 2005 express.Basically all I did was look for TCP dynamic port under IPALL.Made a note of the number and enter it in the administrator.Also used 127.0.0.1 instead of localhost.Works like a charm.

It sounds like you've found the answer. Please respond back if you hit any further problems.

Thanks

|||How do you connect sql server 2005 express to coldfusion mx 7. I have tried everything. What do I use for the username and passsword in Coldfusion Administrator.