Saturday, February 25, 2012

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\SQLEXPRESS
- Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapters
are enabled.
- Windows firewall is disabled
Thanks for suggestionsFrank 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 fac
t
> 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 attachin
g
> tables in an Access DB
> -The instance is: ServerName\SQLEXPRESS
> - Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapter
s
> 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?
>

No comments:

Post a Comment