August 16, 2004 at 12:25 pm
I am trying to design my first database and am using SQL Server 2000 MSDE. No matter what I do I cannot connect to the server with anything but osql. osql seems to work fine but I am trying to use DBDesigner4 (fabforce.net) to build my database (or a model at least to work from) and I cannot establish a connection to the database. I get error messages saying the SQL server does not exist or connection was actively refused. To try and narrow down the problem I tried to connect using a simple VBA script in MS Excel (just an open connection statement then print the status of the connection for confirmation). My script just fails on the connection statement. It wont even print a simple the print statment after the connection and it doesnt yeild any error messages. I have read all I can find on this and I have confirmed that I do have mixed mode authentication set properly (registery value set to 0). I am stumped. Has anyone encountered this before (and better yet, resolved it)?
Thanks in advance.
kmbarlow
August 16, 2004 at 12:34 pm
One more thing I should probably add... I have checked the logs and there doesnt seem to be any information in there pertaining to connect attempts.
Thanks
Kmbarlow
August 16, 2004 at 1:02 pm
Have you run SVRNETCN.exe to enable server protocols (TCP/Named Pipe) for connecting to SQL Server?
August 17, 2004 at 10:05 am
No, but thank you. That did the trick.
Kmbarlow
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply