Cannot remotely connect on SQL Server Instances by name.

Hi all,

On my computer I have installed two instances of SQL Server 2000. The first one is the default instance of SQL Server Personal Edition and the second one is an MSDE instance.

From other PCs on the company LAN I can connect, by name, only to the first one and not to the MSDE instance.

I have tried the combination IP Address, TCP Port and it work fine.

Anyone any ideas?

Thanks in advance,

Stavros Makridis.

did you get this fixed ever?|||

Hi,

the named instance is accessible with MachineName\InstanceName,PortNumber in SQL Server 2000.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Jens K. Suessmeyer wrote:

Hi,

the named instance is accessible with MachineName\InstanceName,PortNumber in SQL Server 2000.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

If tcp port is specified in the connection string, the instance name value is ignored.|||UDP port 1434 must be blocked somehow. SQL Browser needs this port to resolve srv\instance to a valid server:tcp_port.|||He is using SQL 2000, so no SQL Browser.|||

Yes there is. Browser is handled by the first instance of sqlserver internally.

|||

I wasn′t aware of that, do you have some links about this topic and this internal feature ?

|||You can find it in bol and on technet.

Here is an excerpt from bol (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3cc00d3a-487c-4cd9-a155-655f02485fa0.htm):
"Background

Prior to Microsoft SQL Server 2000, only one instance of SQL Server could be installed on a computer. SQL Server listened for incoming requests on port 1433, assigned to SQL Server by the official Internet Assigned Numbers Authority (IANA). Only one instance of SQL Server can use a port, so when SQL Server 2000 introduced support for multiple instances of SQL Server, SQL Server Resolution Protocol (SSRP) was developed to listen on UDP port 1434. This listener service responded to client requests with the names of the installed instances, and the ports or named pipes used by the instance. To resolve limitations of the SSRP system, SQL Server 2005 introduces the SQL Server Browser service as a replacement for SSRP."

Cannot remotely connect on SQL Server Instances by name.

Hi all,

On my computer I have installed two instances of SQL Server 2000. The first one is the default instance of SQL Server Personal Edition and the second one is an MSDE instance.

From other PCs on the company LAN I can connect, by name, only to the first one and not to the MSDE instance.

I have tried the combination IP Address, TCP Port and it work fine.

Anyone any ideas?

Thanks in advance,

Stavros Makridis.

did you get this fixed ever?|||

Hi,

the named instance is accessible with MachineName\InstanceName,PortNumber in SQL Server 2000.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jens K. Suessmeyer wrote:

Hi,

the named instance is accessible with MachineName\InstanceName,PortNumber in SQL Server 2000.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

If tcp port is specified in the connection string, the instance name value is ignored.|||UDP port 1434 must be blocked somehow. SQL Browser needs this port to resolve srv\instance to a valid server:tcp_port.|||He is using SQL 2000, so no SQL Browser.|||

Yes there is. Browser is handled by the first instance of sqlserver internally.

|||

I wasn′t aware of that, do you have some links about this topic and this internal feature ?

|||You can find it in bol and on technet.

Here is an excerpt from bol (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3cc00d3a-487c-4cd9-a155-655f02485fa0.htm):
"Background

Prior to Microsoft SQL Server 2000, only one instance of SQL Server

could be installed on a computer. SQL Server listened for incoming requests on

port 1433, assigned to SQL Server by the official Internet Assigned Numbers

Authority (IANA). Only one instance of SQL Server can use a port, so when SQL

Server 2000 introduced support for multiple instances of SQL Server, SQL Server

Resolution Protocol (SSRP) was developed to listen on UDP port 1434. This

listener service responded to client requests with the names of the installed

instances, and the ports or named pipes used by the instance. To resolve

limitations of the SSRP system, SQL Server 2005 introduces the SQL Server

Browser service as a replacement for SSRP."

Cannot register new server

Hi,
I have a SQL developer edition. I cannont register the server.
the error message i get is that
"the server does not exist or Openconncet"
Ray
hi
just check if the server is up and running.
type "telnet <server name> 1433" in the command prompt and check.
If the window waits for responce, then that means that there is SQL server
available and can listen to the response
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
"New server Registeration fail" wrote:

> Hi,
> I have a SQL developer edition. I cannont register the server.
> the error message i get is that
> "the server does not exist or Openconncet"
> Ray
>
|||Also, the rest of that message is "or Access Denied." Make sure either you
have added the appropriate Windows Login accounts as a SQL Server login, or
that you use SQL Secruity when you first register the server in EM.
You can always change it latter.
By default, the Builtin\Administrators group is added as a system admin.
Log on the host as a local administration. You can then connect and add the
added security.
Sincerely,
Anthony Thomas

"New server Registeration fail" <New server Registeration
fail@.discussions.microsoft.com> wrote in message
news:980EA01E-EB03-46DD-963A-F7C2919B1B89@.microsoft.com...
Hi,
I have a SQL developer edition. I cannont register the server.
the error message i get is that
"the server does not exist or Openconncet"
Ray

Cannot register new server

Hi,
I have a SQL developer edition. I cannont register the server.
the error message i get is that
"the server does not exist or Openconncet"
Rayhi
just check if the server is up and running.
type "telnet <server name> 1433" in the command prompt and check.
If the window waits for responce, then that means that there is SQL server
available and can listen to the response
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"New server Registeration fail" wrote:

> Hi,
> I have a SQL developer edition. I cannont register the server.
> the error message i get is that
> "the server does not exist or Openconncet"
> Ray
>|||Also, the rest of that message is "or Access Denied." Make sure either you
have added the appropriate Windows Login accounts as a SQL Server login, or
that you use SQL Secruity when you first register the server in EM.
You can always change it latter.
By default, the Builtin\Administrators group is added as a system admin.
Log on the host as a local administration. You can then connect and add the
added security.
Sincerely,
Anthony Thomas
"New server Registeration fail" <New server Registeration
fail@.discussions.microsoft.com> wrote in message
news:980EA01E-EB03-46DD-963A-F7C2919B1B89@.microsoft.com...
Hi,
I have a SQL developer edition. I cannont register the server.
the error message i get is that
"the server does not exist or Openconncet"
Ray

Cannot register new server

Hi,
I have a SQL developer edition. I cannont register the server.
the error message i get is that
"the server does not exist or Openconncet"
Rayhi
just check if the server is up and running.
type "telnet <server name> 1433" in the command prompt and check.
If the window waits for responce, then that means that there is SQL server
available and can listen to the response
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"New server Registeration fail" wrote:
> Hi,
> I have a SQL developer edition. I cannont register the server.
> the error message i get is that
> "the server does not exist or Openconncet"
> Ray
>|||Also, the rest of that message is "or Access Denied." Make sure either you
have added the appropriate Windows Login accounts as a SQL Server login, or
that you use SQL Secruity when you first register the server in EM.
You can always change it latter.
By default, the Builtin\Administrators group is added as a system admin.
Log on the host as a local administration. You can then connect and add the
added security.
Sincerely,
Anthony Thomas
"New server Registeration fail" <New server Registeration
fail@.discussions.microsoft.com> wrote in message
news:980EA01E-EB03-46DD-963A-F7C2919B1B89@.microsoft.com...
Hi,
I have a SQL developer edition. I cannont register the server.
the error message i get is that
"the server does not exist or Openconncet"
Ray

Cannot Register Instance of SQL Server 2000

Information:

Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Enterprise Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server A is going to function as a Distributor.
Location: New York.

Server B: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Standard Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server B is going to function as a Subscriber.
Location: London.

Server C: SQL Server 2000 Enterprise Edition. OS is Windows 2000 Advanced
Server. SQL Service pack 3a. Member of domain ABCDomain. Server C
is going to function as a Publisher. Location New York.

Problem: I am setting up a test replication environment prior to going live
with a replication from New York to London. When I try to register
Server A on Server B, I get the error: SQL Server does not exist or
access denied'. I get the same error when I try to register Server
B on Server A. Both boxes can ping the other. I am able to
register Server C (Publisher) on both Server A and B as well as
register both Server A and B on Server C.

I would appreciate your input as to what could be causing this
problem as well as a possible solution.

Thank you in advance."Robert M." <rmizzaro@.integratedbsi.com> wrote in message
news:9ff47a28.0407270533.280efcbd@.posting.google.c om...
> Information:
> Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
> Enterprise Edition. SQL Service pack is 3a. Member of domain
> ABCDomain. Server A is going to function as a Distributor.
> Location: New York.
> Server B: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
> Standard Edition. SQL Service pack is 3a. Member of domain
> ABCDomain. Server B is going to function as a Subscriber.
> Location: London.
> Server C: SQL Server 2000 Enterprise Edition. OS is Windows 2000 Advanced
> Server. SQL Service pack 3a. Member of domain ABCDomain.
Server C
> is going to function as a Publisher. Location New York.
> Problem: I am setting up a test replication environment prior to going
live
> with a replication from New York to London. When I try to
register
> Server A on Server B, I get the error: 'SQL Server does not
exist or
> access denied'. I get the same error when I try to register
Server
> B on Server A. Both boxes can ping the other. I am able to
> register Server C (Publisher) on both Server A and B as well as
> register both Server A and B on Server C.
> I would appreciate your input as to what could be causing this
> problem as well as a possible solution.
> Thank you in advance.

I'm not really sure what you mean by "register" an instance - do you mean
you're using Enterprise Manager locally on Server B, and trying to register
Server A? Or do you mean you're doing something specific with the
replication tools? Either way, one key thing to check would be the service
account used for MSSQL and whether it has access to all the servers. This KB
article discusses many other possibilities:

http://support.microsoft.com/defaul...306&Product=sql

Simon|||I am trying to register the instance via Enterprise Manager locally on
each SQL Server. Also, for a test, I setup MSSQLSERVER and
SQLSERVERAGENT services using a domain administrator. Still I cannot
register Server A (through EM) on Server B or Server B (through EM) on
Server A.

"Simon Hayes" <sql@.hayes.ch> wrote in message news:<41068db6$1_2@.news.bluewin.ch>...
> "Robert M." <rmizzaro@.integratedbsi.com> wrote in message
> news:9ff47a28.0407270533.280efcbd@.posting.google.c om...
> > Information:
> > Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
> > Enterprise Edition. SQL Service pack is 3a. Member of domain
> > ABCDomain. Server A is going to function as a Distributor.
> > Location: New York.
> > Server B: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
> > Standard Edition. SQL Service pack is 3a. Member of domain
> > ABCDomain. Server B is going to function as a Subscriber.
> > Location: London.
> > Server C: SQL Server 2000 Enterprise Edition. OS is Windows 2000 Advanced
> > Server. SQL Service pack 3a. Member of domain ABCDomain.
> Server C
> > is going to function as a Publisher. Location New York.
> > Problem: I am setting up a test replication environment prior to going
> live
> > with a replication from New York to London. When I try to
> register
> > Server A on Server B, I get the error: 'SQL Server does not
> exist or
> > access denied'. I get the same error when I try to register
> Server
> > B on Server A. Both boxes can ping the other. I am able to
> > register Server C (Publisher) on both Server A and B as well as
> > register both Server A and B on Server C.
> > I would appreciate your input as to what could be causing this
> > problem as well as a possible solution.
> > Thank you in advance.
> I'm not really sure what you mean by "register" an instance - do you mean
> you're using Enterprise Manager locally on Server B, and trying to register
> Server A? Or do you mean you're doing something specific with the
> replication tools? Either way, one key thing to check would be the service
> account used for MSSQL and whether it has access to all the servers. This KB
> article discusses many other possibilities:
> http://support.microsoft.com/defaul...306&Product=sql
> Simon

Cannot open user default database. Login failed

Hi,

I have installed SQL Server 2005 Express edition and when i try to run the web site as http://127.0.0.1/SiteName/Login.aspx. I am using default SQL Provider.

Can anyoone please help me? i was struck here from last two days.

System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.

Login failed for user 'XXXXXX\ASPNET'.

Regards,

Pradeep.

hi Pradeep,

please verify the default database for \ASPNET login is available on the target server...

regards

|||See the Security matrix form here:

http://msdn2.microsoft.com/en-us/library/aa302377.aspx

You either can create the ASPNET user on the server, create another one and specify it within the web.config file, or specify in the web.config file, that you want to use impersonation. (Depending on your needs)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi

Thank U verymuch for the reply. I have created the ASPNET User using Microsoft SQL Server Management Studio Express but the result is same.

How can i see the default database for ASPNET user....

Regards,

Pradeep.

|||

Hi

Thank U for the reply. I have created ASPNET user in the database using Microsoft SQL server Management Studio Express and in web config file i have added

<identity impersonate="true"/>

<authentication mode="Forms" />

but still the reult is same as

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'MIS-2\ASPNET'.

Hope this might be bug in SQL Server in SQL Server 2005 Express edition.

Regards,

Pradeep

|||

Hi,

ok we are getting closer. The error is related to the fact that you want to redirect to a database where is not granted any access to. Automatic redirection of Users is done in either of the two ways. You have a connection string where no "Inital Catalog"
keyword is specified, then the user will be redirected to his default database which every user has. If you want to change that, you can use the GUI and set the default database to another one where he is granted access to. (You can also use the sp_defaultdb procedure if you prefer the non-Gui version). if you mentioned the "Initial Catalog" in the catalog you will have to make sure that the connecting user (in your case the
ASPNET user) has access to the database mentioned in as the keyword value.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi,

I am using the default sql provider model.

one more thing is i am having sql server 2000 in (mixed mode authentcation) and sql server 2005 express edition(in windows authentication), is there any problem related to this.

in sql server 2000 i have given the ASPNET user defult database as master and in sql server 2005 i did the same.

so, does these settings has any impact on the default provider model in ASP.NET 2.0?

Regards,

Pradeep

|||

Hi Pradeep,

The error generally comes when the user tried to connect Database for which he don't have access permission so you may use sp_grantdbaccess to grant db access permission and refer below KBs for more

http://support.microsoft.com/kb/321698/en-us

http://support.microsoft.com/kb/316989/en-us

http://support.microsoft.com/kb/824308/en-us

http://support.microsoft.com/kb/821498/en-us

http://support.microsoft.com/kb/308157/en-us

http://support.microsoft.com/kb/301240/en-us

Hemantgiri S. Goswami

|||

An answer provided by monishjain from ASP.net forum

Steps (Windows XP):

Go to Control Panel -> Administrative Tools -> Computer Management -> Local Users and Groups -> Users -> ASPNET

Right Click on ASPNET and select Properties

Go to Member Of tab.

Click on Add -> Advanced -> Find Now

Select SQLServer2005MSSQLUser$<machinename>$SQLExpress

Click on Ok -> Ok - >Apply

Close all the windows and reboot your machine. It should work now.

Cannot open user default database. Login failed

Hi,

I have installed SQL Server 2005 Express edition and when i try to run the web site as http://127.0.0.1/SiteName/Login.aspx. I am using default SQL Provider.

Can anyoone please help me? i was struck here from last two days.

System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.

Login failed for user 'XXXXXX\ASPNET'.

Regards,

Pradeep.

hi Pradeep,

please verify the default database for \ASPNET login is available on the target server...

regards

|||See the Security matrix form here:

http://msdn2.microsoft.com/en-us/library/aa302377.aspx

You either can create the ASPNET user on the server, create another one and specify it within the web.config file, or specify in the web.config file, that you want to use impersonation. (Depending on your needs)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi

Thank U verymuch for the reply. I have created the ASPNET User using Microsoft SQL Server Management Studio Express but the result is same.

How can i see the default database for ASPNET user....

Regards,

Pradeep.

|||

Hi

Thank U for the reply. I have created ASPNET user in the database using Microsoft SQL server Management Studio Express and in web config file i have added

<identity impersonate="true"/>

<authentication mode="Forms" />

but still the reult is same as

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'MIS-2\ASPNET'.

Hope this might be bug in SQL Server in SQL Server 2005 Express edition.

Regards,

Pradeep

|||

Hi,

ok we are getting closer. The error is related to the fact that you want to redirect to a database where is not granted any access to. Automatic redirection of Users is done in either of the two ways. You have a connection string where no "Inital Catalog"
keyword is specified, then the user will be redirected to his default database which every user has. If you want to change that, you can use the GUI and set the default database to another one where he is granted access to. (You can also use the sp_defaultdb procedure if you prefer the non-Gui version). if you mentioned the "Initial Catalog" in the catalog you will have to make sure that the connecting user (in your case the
ASPNET user) has access to the database mentioned in as the keyword value.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

I am using the default sql provider model.

one more thing is i am having sql server 2000 in (mixed mode authentcation) and sql server 2005 express edition(in windows authentication), is there any problem related to this.

in sql server 2000 i have given the ASPNET user defult database as master and in sql server 2005 i did the same.

so, does these settings has any impact on the default provider model in ASP.NET 2.0?

Regards,

Pradeep

|||

Hi Pradeep,

The error generally comes when the user tried to connect Database for which he don't have access permission so you may use sp_grantdbaccess to grant db access permission and refer below KBs for more

http://support.microsoft.com/kb/321698/en-us

http://support.microsoft.com/kb/316989/en-us

http://support.microsoft.com/kb/824308/en-us

http://support.microsoft.com/kb/821498/en-us

http://support.microsoft.com/kb/308157/en-us

http://support.microsoft.com/kb/301240/en-us

Hemantgiri S. Goswami

|||

An answer provided by monishjain from ASP.net forum

Steps (Windows XP):

Go to Control Panel -> Administrative Tools -> Computer Management -> Local Users and Groups -> Users -> ASPNET

Right Click on ASPNET and select Properties

Go to Member Of tab.

Click on Add -> Advanced -> Find Now

Select SQLServer2005MSSQLUser$<machinename>$SQLExpress

Click on Ok -> Ok - >Apply

Close all the windows and reboot your machine. It should work now.

Cannot open user default database. Login failed

Hi,

I have installed SQL Server 2005 Express edition and when i try to run the web site as http://127.0.0.1/SiteName/Login.aspx. I am using default SQL Provider.

Can anyoone please help me? i was struck here from last two days.

System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.

Login failed for user 'XXXXXX\ASPNET'.

Regards,

Pradeep.

hi Pradeep,

please verify the default database for \ASPNET login is available on the target server...

regards

|||See the Security matrix form here:

http://msdn2.microsoft.com/en-us/library/aa302377.aspx

You either can create the ASPNET user on the server, create another one and specify it within the web.config file, or specify in the web.config file, that you want to use impersonation. (Depending on your needs)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi

Thank U verymuch for the reply. I have created the ASPNET User using Microsoft SQL Server Management Studio Express but the result is same.

How can i see the default database for ASPNET user....

Regards,

Pradeep.

|||

Hi

Thank U for the reply. I have created ASPNET user in the database using Microsoft SQL server Management Studio Express and in web config file i have added

<identity impersonate="true"/>

<authentication mode="Forms" />

but still the reult is same as

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'MIS-2\ASPNET'.

Hope this might be bug in SQL Server in SQL Server 2005 Express edition.

Regards,

Pradeep

|||

Hi,

ok we are getting closer. The error is related to the fact that you want to redirect to a database where is not granted any access to. Automatic redirection of Users is done in either of the two ways. You have a connection string where no "Inital Catalog"
keyword is specified, then the user will be redirected to his default database which every user has. If you want to change that, you can use the GUI and set the default database to another one where he is granted access to. (You can also use the sp_defaultdb procedure if you prefer the non-Gui version). if you mentioned the "Initial Catalog" in the catalog you will have to make sure that the connecting user (in your case the
ASPNET user) has access to the database mentioned in as the keyword value.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

I am using the default sql provider model.

one more thing is i am having sql server 2000 in (mixed mode authentcation) and sql server 2005 express edition(in windows authentication), is there any problem related to this.

in sql server 2000 i have given the ASPNET user defult database as master and in sql server 2005 i did the same.

so, does these settings has any impact on the default provider model in ASP.NET 2.0?

Regards,

Pradeep

|||

Hi Pradeep,

The error generally comes when the user tried to connect Database for which he don't have access permission so you may use sp_grantdbaccess to grant db access permission and refer below KBs for more

http://support.microsoft.com/kb/321698/en-us

http://support.microsoft.com/kb/316989/en-us

http://support.microsoft.com/kb/824308/en-us

http://support.microsoft.com/kb/821498/en-us

http://support.microsoft.com/kb/308157/en-us

http://support.microsoft.com/kb/301240/en-us

Hemantgiri S. Goswami

|||

An answer provided by monishjain from ASP.net forum

Steps (Windows XP):

Go to Control Panel -> Administrative Tools -> Computer Management -> Local Users and Groups -> Users -> ASPNET

Right Click on ASPNET and select Properties

Go to Member Of tab.

Click on Add -> Advanced -> Find Now

Select SQLServer2005MSSQLUser$<machinename>$SQLExpress

Click on Ok -> Ok - >Apply

Close all the windows and reboot your machine. It should work now.

Cannot open http://localhost/reports

Hi Folks,

I've just installed SQL Server 2005 Standard Edition with Reporting Services.

Via Visual Studio, I am able to create and run reports without an issue, but I am unable to launch the web element of Reporting Services, via http://localhost/reports

I get the message "Page cannot be found".

I have run the install a second time in the hope of a "repair" but it has made no difference.

FYI, from within IIS, I cannot see reference to a website for "reports".

Any ideas?

If there is not reference for Report or ReportServer, then you probably did not install the Reporting Server. make sure that the prerequisites are fullfilled before installing the server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||You may have unchecked the option to configure the server during the install. Try launching the RS 2005 Configuration tool from Start->All Programs->Microsoft SQL Server 2005->Configuration Tools->Reporting Services Configuration. This should allow you to check of everything is set up correctly.

cannot open Enterprise Manager

Hi All,
Several months ago, I installed SQL Server 2000
Development edition on my Windows XP laptop.
Today, for the first time, for some unknown reason I
cannot open the Enterprise Manager. I have been able to
open it, practically everyday, for the past few months.
I am getting the following Microsoft Management Console
error message:
"MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an
MMCconsole, or was created by a later version of MMC.
This may also be because you do not have sufficient
access rights to the file."
SQL Server Enterprise Manager.MSC file does exist in
I have all access rights to my laptop!
Any idea what have caused this problem and how could I
fix it.
Thank you,
Mitra
Try uninstalling / reinstalling the client tools, and/or reapplying SP3a.
http://www.aspfaq.com/
(Reverse address to reply.)
"mitra fatholahi" <mitra928@.hotmail.com> wrote in message
news:1b2d201c44f45$da666d60$a001280a@.phx.gbl...
> Hi All,
> Several months ago, I installed SQL Server 2000
> Development edition on my Windows XP laptop.
> Today, for the first time, for some unknown reason I
> cannot open the Enterprise Manager. I have been able to
> open it, practically everyday, for the past few months.
> I am getting the following Microsoft Management Console
> error message:
> "MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an
> MMCconsole, or was created by a later version of MMC.
> This may also be because you do not have sufficient
> access rights to the file."
> SQL Server Enterprise Manager.MSC file does exist in
> I have all access rights to my laptop!
> Any idea what have caused this problem and how could I
> fix it.
> Thank you,
> Mitra
>
>
>
|||The file that becomes the SQL Server Enterprise Manager.MSC is named
SQLEM.MSC on the SQL Server 2000 CD. You can try copying the one form the
CD, renaming it and replcacing the one on disk.
Rand
This posting is provided "as is" with no warranties and confers no rights.

cannot open Enterprise Manager

Hi All,
Several months ago, I installed SQL Server 2000
Development edition on my Windows XP laptop.
Today, for the first time, for some unknown reason I
cannot open the Enterprise Manager. I have been able to
open it, practically everyday, for the past few months.
I am getting the following Microsoft Management Console
error message:
"MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an
MMCconsole, or was created by a later version of MMC.
This may also be because you do not have sufficient
access rights to the file."
SQL Server Enterprise Manager.MSC file does exist in
I have all access rights to my laptop!
Any idea what have caused this problem and how could I
fix it.
Thank you,
MitraTry uninstalling / reinstalling the client tools, and/or reapplying SP3a.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"mitra fatholahi" <mitra928@.hotmail.com> wrote in message
news:1b2d201c44f45$da666d60$a001280a@.phx.gbl...
> Hi All,
> Several months ago, I installed SQL Server 2000
> Development edition on my Windows XP laptop.
> Today, for the first time, for some unknown reason I
> cannot open the Enterprise Manager. I have been able to
> open it, practically everyday, for the past few months.
> I am getting the following Microsoft Management Console
> error message:
> "MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an
> MMCconsole, or was created by a later version of MMC.
> This may also be because you do not have sufficient
> access rights to the file."
> SQL Server Enterprise Manager.MSC file does exist in
> I have all access rights to my laptop!
> Any idea what have caused this problem and how could I
> fix it.
> Thank you,
> Mitra
>
>
>|||The file that becomes the SQL Server Enterprise Manager.MSC is named
SQLEM.MSC on the SQL Server 2000 CD. You can try copying the one form the
CD, renaming it and replcacing the one on disk.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql

cannot open Enterprise Manager

Hi All,
Several months ago, I installed SQL Server 2000
Development edition on my Windows XP laptop.
Today, for the first time, for some unknown reason I
cannot open the Enterprise Manager. I have been able to
open it, practically everyday, for the past few months.
I am getting the following Microsoft Management Console
error message:
"MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an
MMCconsole, or was created by a later version of MMC.
This may also be because you do not have sufficient
access rights to the file."
SQL Server Enterprise Manager.MSC file does exist in
I have all access rights to my laptop!
Any idea what have caused this problem and how could I
fix it.
Thank you,
MitraTry uninstalling / reinstalling the client tools, and/or reapplying SP3a.
http://www.aspfaq.com/
(Reverse address to reply.)
"mitra fatholahi" <mitra928@.hotmail.com> wrote in message
news:1b2d201c44f45$da666d60$a001280a@.phx
.gbl...
> Hi All,
> Several months ago, I installed SQL Server 2000
> Development edition on my Windows XP laptop.
> Today, for the first time, for some unknown reason I
> cannot open the Enterprise Manager. I have been able to
> open it, practically everyday, for the past few months.
> I am getting the following Microsoft Management Console
> error message:
> "MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an
> MMCconsole, or was created by a later version of MMC.
> This may also be because you do not have sufficient
> access rights to the file."
> SQL Server Enterprise Manager.MSC file does exist in
> I have all access rights to my laptop!
> Any idea what have caused this problem and how could I
> fix it.
> Thank you,
> Mitra
>
>
>|||The file that becomes the SQL Server Enterprise Manager.MSC is named
SQLEM.MSC on the SQL Server 2000 CD. You can try copying the one form the
CD, renaming it and replcacing the one on disk.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Cannot open database"..."requested by the login...??

Hello,

I am using Visual Web Developer 2005 Express Edition and I am following the book:"Beginning ASP.NET 2.0 E-commerce in C# . I am encountering a problem and I haven't got the slightest idea how to solve the problem.

(If you have the book I got to p98)

If I debug then I get the next error: cannot open database"..." requested by the login...

In the book I had to make a GenericDataAccess.cs. What follows are snippets where the error occurs.

public static DataTable ExecuteSelectCommand(DbCommand command)

{

DataTable table

try

{

command.Connection.Open();

DbDataReader reader = command.ExecuteReader();

table = new DataTable();

table.Load(reader);

reader.Close();

}

catch (Exception ex)

{

Utilities.LogError(ex);

throw ex; //this is where my error occurs when I debug it

}

finally

{

commandConnection.close();

}

return table;

}

Ideas and sollutions are more than welcome :-)

YES!!!

I'm currently using the same book and having the same problem too!

May i ask if how did you bypass the SQL Express part? Which programs did you use to substitute SQL Express Manager? I'm having problems with my database connection.

Would appreciate if you can share.

Thanks!

Cannot open database during merge replication

Hi All,
I am replicating an SQL2005 express machine to SQL2005 standard edition server using merge replication.

I have a simple VB application using ADO polling msMerge_history at the subscriber every second so that i can show the end user the progress of the replication.

When the subscription first subscribes and after the initial snapshot is applied replication downloads all changes from the server that have been changed since the snapshot was created.

Towards the end of this download faze the VB polling application fails with "Cannot open database "DBName" requested by the login. The login failed."

This connection fails 4 or 5 times and then normal polling resumes. The scary thing is that sometimes when the polling connection fails the merge replication does not complete and if i check msMerge_Sessions the "runstatus" is stuck at 3 (InProgress).

1) Is the reason the ADO polling connection fails because of some sort of lock between replication and reading the system tables?
2) Is replication getting stuck because of locks?
3) What can i do to get around this?

cheers,
Tim

Hello Tim,

Please try to use uncommited read isolation level (or SELECT ... WITH (NOLOCK) )when querying msMerge_Sessions table.

But result row set from this query contains uncommitted transactions.

This posting is provided AS IS with no warranties, and confers no rights

Cannot Open Database "XXXX" requested by login. The login failed. Login failed for user xx

hi,

so i have a new box and I'm trying to get my websites and SQL Server 2005 Standard Edition working on it, but the pages give me the following error when I try to load them:

"Cannot Open Database "XXXX" requested by login. The login failed. Login failed for user 'xxx'"

Everything seems exactly the same settings and user-wise from my old box to my new one, but nevertheless everything I've tried gives me the same error.

I've tried creating new users in SQL Server and giving them appropriate permissions to my database. I've even tried just using the built in 'sa' account. Nothing seems to change the error, except when I give it the incorrect password then it just says 'login failed'

This leads me to believe that i'm successfully logging into the SQL Server, but it doesn't want to give me access to the database I'm requesting access too. But "apparently" the account i'm using should have access to the database. If nothing else the 'sa' account should, but that didn't work either.

I'm stumped. Any ideas?

Check the database settings for user you are trying to login with and make sure they have permission and deny data reader is not checked.|||yep, the user currently has SELECT, UPDATE, INSERT, DELETE, and CONNECT permission selected.|||Look in the database properties under users and make sure the user has permissions there|||yep, the user is even marked as the dbowner.|||

here is my connection string just in case it's something funny there, but this connection string works on my old box with apparently the exact same settings

<

addname="ConnectionString"connectionString="Server=ServerName;Database=MyDatabase;User ID=MyID;Password=MyPassword;Trusted_Connection=False"providerName="System.Data.SqlClient" />|||

ha!

the problem was that when I restored my database (from the old box to the new box), SQL Server replaced a certain character in the name with a different character. Namely replaced "\" with "_".

So it wasn't finding the database... I didn't need those five hours of my life anyways ;-)

Cannot open a connection with SQL Server 2005 Developer Edition.

I have installed on one computer Sql Server 2005 Developer Edition (CTP Version) together with a Visual Studio 2005 Beta Edition (July Version) and after configuration some properties by example the Network access, I had a lot of errors from the SQL Server Management Studio received(The most of them are a Connection timeout error but others errors too).
In the same time I have made a test program to test the new SQL Server 2005 using DB Library or ATL OLE DB Consumer Templates.
The Both test programs are not running because I cannot open a connection on the SQL Server.
I've tried using the Windows Authentification and the SQL Server Authentification too. The both methods are not able to connect with the SQL Server.
The Programs are written in Visual C++ under the Visual Studio 2005.
I need help to my problems!
First why I cannot connect to the Sql Server. With DB Library example I was able to do it with a Beta Version from SQL Server 2005 but not any more with the CTP Version.
Why I cannot connect with the ATL OLE DB Consumer Templates ?
I want to hear some experiences from others developers with this CTP Version from SQL Server 2005.
It is really so buggy or it is not compatible with Window Server 2003 or it is because after installing the SQL Server 2005 I have made an update of the Visual Studio 2005 to be able to create Projects in Visual C++ and run some examples ?
The problem was that with the Visual Studio that it is coming with the SQL Server I was not able to create any Project under Visual C++ because I was receiving an error that the Template for the Visual C++ failed.
I need help !

For the detailed information about the Versions please read the next list:

Microsoft SQL Server Management Studio - Version 9.0.1187.
MDAC - Version 2000.086.1830.00(srv03_sp1_rtm.050324_1447)
Microsoft .Net Framework - Version 2.0.50712.6.
Microsoft Visual Studio 2005 - Version 8.0.50712.6(lab23df.050712-0600)

The Operating System it is an Windows Server 2003 Professional Version with SP1.
What are the specific errors you are seeing when you try to connect to SQL Server. Could you please post your sample code
SQL Server projects are only available in Visual Studio pro. SKU and above. What SKU of Visual Studio are you using. Are you able to get C# and VB.NET SQL Server projects working?

Thanks,
-Vineet.|||So first what you've asked:
The Visual Studio Version it is :
Team Edition for Software Architects. Version 8.0.50712.6(lab23df.050712-0600)
It is installed from MSDN Team Suite DVD Beta 2 Version.
The Windows it is Windows 2003 Server Enterprise Edition(first time I was wrong, it was no Profesional version) with SP1.
The c# or VB.Net projects are working just fine. Only the connection to Sql Server it is not working.
The Sample code I will send you in the project on your email address:vineetr@.microsoft.com. The project it is imported from Visual Studio 6.0 Samples and coverted to Visual Studio 2005. It is writed in unmanaged code in Visual c++. Please don't forget to copy the db library files that are included in the archive on C:\ or to change the path for include in the code.
In the Sample I am using two tables here it is the SQL code to create the tables:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TestTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[TestTable]

GO

CREATE TABLE [dbo].[TestTable] (

[Id] uniqueidentifier ROWGUIDCOL NOT NULL ,

[Text1] [varchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,

[Text2] [char] (10) COLLATE Latin1_General_CI_AS NOT NULL ,

[Int1] [int] NOT NULL ,

[Float1] [float] NOT NULL ,

[Short1] [smallint] NOT NULL

) ON [PRIMARY]

GO

CREATE CLUSTERED INDEX [index_clustered] ON [dbo].[TestTable]([Id] DESC ) ON [PRIMARY]

GO

CREATE INDEX [index_mixt] ON [dbo].[TestTable]([Int1] DESC , [Short1] DESC ) ON [PRIMARY]

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TestTable2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[TestTable2]

GO

CREATE TABLE [dbo].[TestTable2] (

[autoid] [int] IDENTITY (1, 1) NOT NULL ,

[value1] [int] NULL ,

[value2] [int] NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[TestTable2] WITH NOCHECK ADD

CONSTRAINT [PK_TestTable2] PRIMARY KEY CLUSTERED

(

[autoid]

) ON [PRIMARY]

GO

In the mean time I have made some more research trying to find where the problem it is located. In the Sql Server components or in the library components that I am using in my code example (DB Library and ATL OLE DB Comsumer Templates library) and I found the next problem:
In the Microsoft Management Studio I have made the next four steps:
1. Create the tables ruuning the upper script. After this you will find in the database two sample tables TestTable and TestTable2.
2.Run the Query : Select * from TestTable2. No result but no error too.
3.Run the Query :Insert into testTable2 values (1,1). No I get allready the timeout Error and the query it is making the insert in the Table (Unexpected behavior).
4.Run the Query again: Select * from TestTable2. To check and see if the insert it is made. Now we can see in the table one row with the just inserted result. I got an error and the query it it succesfully executed.
Please see the archive that I will send you in there you will find the print screens.

So my opinion it is that the problem it is in the SQL Server itself.
This Timeout error I got it in the Microsoft Management Studio when I try to update some properties from Databases, Updating properties from the Server itself or Scripting a table etc...

I my head it stays one modification that I have made in the timeout value for the connections in the SQL Server properties. I have seted the value to 6000 and after a while again to 0(no limit). And after this modification I've retarted the computer (all the SQL server services should read again the settings after restart).

This can be one reason. The second reason can be: I have made some modification for the protocolls to access the SQL Server from another remote computer. I have read that default it cannot be accesed remote.
Anyhow I have undone all the modification and still the SQL it not reacting normally (when I access the Sql Server locally- or just from the Microsoft Management Studio ).

So please read your email to get the sample code and the print screen with th errors. I f you need more print screen with other error please tell me.
I wait for your help.

Thanks,
Vasile.|||I want help.
Do you need more infos ?
Have you found something ?
Can somebody help ?
Maybe I should wait for the release version.

Cannot open .sdf file in QA3.0

Hi,

We are using VS 2005 with SQL Server Mobile Edition. We created the .sdf file on the desktop and added this file to our VS project and set the Build Action to content. Next we deployed our app on Symbol PDA which has Windows CE 5.0 as the OS. We followed the following steps:

1. Deploy the app.

2. Install .NET CF 2.0

3. System_SR_ENU.CAB

4. sqlce30.wce5.armv4i.CAB

5. sqlce30.dev.ENU.wce5.armv4i.CAB

6. sqlce30.repl.wce5.armv4i.CAB

We now tried to double-click the .sdf file in PDA to open in QA3 but we get error.:

Error: 0x80004005 E_FAIL

Native Error (0)

Description: Interface defining error: IID_IDBInitialize

Param. 0:0

Param. 1:0

Param. 2:0

Param. 3:

Param. 4:

Param. 5:

What could be the issue?

Because of this, we unable to run the app since in our login form, this database is not available and hence we cannot proceed.

Regards,

Vilas

Please make sure that sqlceoledb30.dll is on the device and registered. The easiest way to do this is to install the repl cab (which you have done). In this case I suggest that you reinstall it and try again.

I usually install the dev cab last, but this should have no effect...

|||

I did as you said. Also found that my .sdf file was created on SQL Mobile Server and therefore did not work on PDA which has CE OS. Now I created the .sdf file on SQL CE and deployed on PDA. I can now open the .sdf file in QA 3.0 of PDA. Now when I try to access the same .sdf file via VS 2005 C# app, I get the error again. But I can run the same on Emulator without any problems. Any reason why?

Regards,

vnj

|||When you refer to a VS2005 C# application do you mean a desktop application? If so, please make sure you install SQL Compact Edition 3.1 on the desktop.

Cannot make New role assignments

New role assignment does not work on my new installation of SQL Reporting Services Enterprise edition on a Windows 2003 server. From Report Manager I navigate to: Home->Properties and select 'New Role Assignment'. I fill in a local user and select the 'Browser' role and click 'OK'. Nothing happens - there is no post-back. I have the same problem for 'Site Settings'. It's as if the Report Manager is running in read-only mode. Do I need to change some configuration to facilitate changes?
Thanks,
--steveDo you see any script errors? They would show up in the lower left corner
of IE.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"stark" <stark@.discussions.microsoft.com> wrote in message
news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> New role assignment does not work on my new installation of SQL Reporting
Services Enterprise edition on a Windows 2003 server. From Report Manager I
navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
local user and select the 'Browser' role and click 'OK'. Nothing happens -
there is no post-back. I have the same problem for 'Site Settings'. It's as
if the Report Manager is running in read-only mode. Do I need to change some
configuration to facilitate changes?
> Thanks,
> --steve|||Dan,
I'm having the same problem on trying to create New Role on both spots as the previous poster. There is no script errors in lower left hand corner. The button "New Role" does not even post back to the browser as I always thought "submit" uses the method specified in form action? Any rate the button is not working and I'm using Windows 2003 as well with lastest Framework 1.1.
HTML Output from "EditGroup.aspx"
<input type="submit" name="ui_btnCreateNewRole" value="New Role" id="ui_btnCreateNewRole" class="msrs-button" />
"Daniel Reib [MSFT]" wrote:
> Do you see any script errors? They would show up in the lower left corner
> of IE.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "stark" <stark@.discussions.microsoft.com> wrote in message
> news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> > New role assignment does not work on my new installation of SQL Reporting
> Services Enterprise edition on a Windows 2003 server. From Report Manager I
> navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
> local user and select the 'Browser' role and click 'OK'. Nothing happens -
> there is no post-back. I have the same problem for 'Site Settings'. It's as
> if the Report Manager is running in read-only mode. Do I need to change some
> configuration to facilitate changes?
> > Thanks,
> > --steve
>
>|||I found the a partial work around to get access to exisitng parent roles.
When you create a report folder, and you click on the report folder, you will have a "security" link in left hand nav. This allowed me to assign to Browser role which I did not have access to under Parent site setting and properties. Also it will ask if youre sure you want to use specific security on that folder, you must say Yes. You can always revert back using the button provided.
"Daniel Reib [MSFT]" wrote:
> Do you see any script errors? They would show up in the lower left corner
> of IE.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "stark" <stark@.discussions.microsoft.com> wrote in message
> news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> > New role assignment does not work on my new installation of SQL Reporting
> Services Enterprise edition on a Windows 2003 server. From Report Manager I
> navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
> local user and select the 'Browser' role and click 'OK'. Nothing happens -
> there is no post-back. I have the same problem for 'Site Settings'. It's as
> if the Report Manager is running in read-only mode. Do I need to change some
> configuration to facilitate changes?
> > Thanks,
> > --steve
>
>|||We have the same problem on our reporting server as well (just after
we made the last SP installation), new rule and move report actions
are not working.
After clicking on the "OK" nothing happen, no script error or any
other error indication can be found.
Any ideas?|||Hi,
this should be it:
on the server run:
aspnet_regiis -c
from the .Net framwork dir.|||I have the same problem. This aspnet_regiis didn't solve it for me...
any other suggestions?
elad@.cydoor.com (Elad) wrote in message news:<2ba7f8ad.0408041410.38bd9598@.posting.google.com>...
> Hi,
> this should be it:
> on the server run:
> aspnet_regiis -c
> from the .Net framwork dir.|||I had the problem described above... and 'aspnet_regiis -c' worked out.
Win 2003 Server, SQL Srvr w/ sp3 and RS w/ sp1.
In case this helps anyone...
The installation had a problem (25619) with virtual directories and I had to
create them manually (setup parameter -rsdonotcreatevirtualdirectories=true)
which I found in a kb article. I followed the steps to create the vir dir's
after the install and everything functioned except for the problem described
in this thread.
Perhaps the following kb article should be updated with a step to execute
aspnet_regiis -c from the .net framework dir.
http://support.microsoft.com/?kbid=867872
"Scott Stonehouse" wrote:
> I have the same problem. This aspnet_regiis didn't solve it for me...
> any other suggestions?
> elad@.cydoor.com (Elad) wrote in message news:<2ba7f8ad.0408041410.38bd9598@.posting.google.com>...
> > Hi,
> >
> > this should be it:
> >
> > on the server run:
> > aspnet_regiis -c
> >
> > from the .Net framwork dir.
>

Cannot Install Workstation Components - Missing Management Studio

Hello,

I have installed SQL Server 2K5 Developer Edition x64, when viewing the option under Start -> All Programs -> Microsoft SQL Server 2005, I do not have the option for Management Studio.

When I attempt to install workstation components I get a message claiming the components I am attempting to install are already installed on the machine and the install will not let me continue.

Any help would be appreciated.

Thanks,

CC

-

Further details, I installed SQL Server after .Net 2K5.

Once I removed all SQL Server components, then re-installed SQL Server 2K5 all appropriate tools were present.

CC

-

|||

While installing , to get tools, you need to select Workstation components from the same window where you sleect Services. If the services are already installed, then go to Control Pannel -- Add/Remove Prorgamm -- Sql server -- Change/Remove -- choose Change and select the Workstation components. It will install only Components. If you are not installed any services, then Install the services and worksation components ...

Madhu

|||

Thanks Madhu,

I resolved the issue prior to you posting by removing SQL Server and SQL Express (installed via .Net 2005 Install). Upon re-installing SQL Server 2005 Dev I was able to access SSMS. I will keep this in mind if I experience this behavior again

Thanks again,

CC

-