Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JeReLo
Starting Member
16 Posts |
 Posted - 2008-04-06 : 23:48:18
|
| I am trying to run aspnet_regsql to set up the membership tables on this SQL 2005 server. It’s a new installation of SQL 2005, using "SQL Server and Windows Authentication mode" Security.I followed the directions at http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 to enable remote connections, enabling the browser service, and opening the firewall. Under SQL Server Configuration manager, I see the protocols for Shared Memory, Named Pipes, and TCP/IP are enabled. Also the Services SQL Server, Server Agent, and Server Browser are automatically running.But when I run aspnet_regsql I get the error: Unable to connect to SQL Server database (because of error 40 – could not open a connection to SQL Server).What else could be needed to allow this connection? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-07 : 23:40:05
|
| Did you specify correct sql instance name? Tried connect with ip address and port number? |
 |
|
|
JeReLo
Starting Member
16 Posts |
Posted - 2008-04-08 : 01:54:41
|
| thank you, I needed to specify the full name (computer/instance). |
|
|
|
|
|
|
Configuration to allow me to run aspnet_regsql ?