|
Home > Archive > MS SQL Server > October 2006 > can't open SQLserver 2005 express with management studio
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
can't open SQLserver 2005 express with management studio
|
|
|
| Using: Windows 2003 server, SQL Server 2005 Express, SQl server management
studio.
I have an SQL server 2005 express database installed in the server but I
can't acces it with management studio. The error is:
"when connecting to sql server 2005, this failure may be caused by the fact
that under the default settings SQL server does not allow remote
connections--- errror locating Server\Instance"
note that:
- database is installed in the local machine.
- remote connections are enabled
-I CAN access database from my asp.net application and using ODBC attaching
tables in an Access DB
-The instance is: ServerName\SQLEXPRES
S
- Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapters
are enabled.
- Windows firewall is disabled
Thanks for suggestions
| |
|
|
Frank wrote:
> Using: Windows 2003 server, SQL Server 2005 Express, SQl server management
> studio.
>
> I have an SQL server 2005 express database installed in the server but I
> can't acces it with management studio. The error is:
>
> "when connecting to sql server 2005, this failure may be caused by the fact
> that under the default settings SQL server does not allow remote
> connections--- errror locating Server\Instance"
>
> note that:
>
> - database is installed in the local machine.
> - remote connections are enabled
> -I CAN access database from my asp.net application and using ODBC attaching
> tables in an Access DB
> -The instance is: ServerName\SQLEXPRES
S
> - Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapters
> are enabled.
> - Windows firewall is disabled
>
> Thanks for suggestions
Are you running studio manager locally on the same server?
| |
|
| Yes, I'm running studio manager locally on the same server
"Ken" <kshapley@sbcglobal.net> ha scritto nel messaggio
news:1158625215.196916.240230@m73g2000cwd.googlegroups.com...
>
> Frank wrote:
>
> Are you running studio manager locally on the same server?
>
|
|
|
|
|