problems with data source for SQL Server Express

[againstTheWind]

I just installed SQL Server Express. I have successfully logged in and created a database with the management studio. However, I keep getting a "not accepting connections error" when trying to create an ODBC data source. All of the help material describes how to add a data source for Visual basic express but I would like to use a source for Dreamweaver.

Anyway, I tried Windows and SQL Server authentication (after creating a user using sql server authentication).

I'm stuck now. I thought I read by default that SQL Server Express does not accept connections but Management Studio Express is connection to it.

Any ideas?? I looked everywhere that I could.

 

[againstTheWind]

FYI:

I also verified that the SQL Server service was running through the configuration manager. It automatically starts.

Thanks!

 

[woogoo]

I've had the same type of problem myself and I solved it by turning on TCP/IP so I can talk to the server by IP address.

This may be a solution for yourself.

 

[gmmastros]

Try this...

In the "Object Explorer" window, right click the server
Click properties
Click "Connections" tab
Make sure "Allow remote connections to this server" is selected.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[againstTheWind]

I forgot to mention that everything is running on my machine - I am not making any remote connections. However, the "allow remote connections" checkbox was checked. So..... I should be allowing remote connections anyway.

 

[againstTheWind]

Any ideas?

 

[mreigler]

Check your sql server instance name. By default SQL Express installs with an instance name of SQLEXPRESS, but your ODBC connection defaults to MSSQLSERVER. When you add your connection you may need to include the instance name as well as the computer name for the datasource of your connection.
i.e. datasource='MyComputerName\SqlExpress'



Mike Reigler
Melange Computer Services, Inc