Can''t Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

Have just installed June CTP on a new laptop build and am having problems getting the AdventureWorks AS database deployed. Using a named instance of SQL Server 2005 (which houses the AdventureWorksDW database) and a named instance of Analysis Services 2005 (which should be getting the deployed database).

After opening the sample solution in BIDS, I changed the data source definition to point to my SQL Server 2005 instance (laptop\sql2005). Tested fine. Then modified the project properties to use the Analysis Services 2005 instance as the deployment location (also laptop\sql2005). Everything looks fine, but when I try to deploy, I get the following three errors:

Error 1: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'localhost' server.

Error 2: Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'localhost' server.

Error 3: Either a connection cannot be made to the localhost\SQL2005 server, or Analysis Services is not running on the computer specified.

So, it looks as if the deployment process is somehow trying to connect to "localhost" instead of my machine name and it also seems as if there's a problem with the SQLBrowser service. I've checked and the service is running.

Probably something silly that I'm either forgetting or overlooking. Anyone?

Thanks,
Dave Fackler
Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler
|||Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler wrote:

Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler

|||I was having the same problem yesterday and found that the Analysis Services service was stopped. No idea on how, but after starting it my connection-related deployment problem went away.|||

Wolfgang W. wrote:

Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler

|||

Just out of curiosity has anyone resolved this one as I have the same problem with NO MINING.

regards Steve

|||

Hi,

I also faced same issue while trying to deploying AdvantureWords Analysis service.

I changed the following setting and after that i am able to deploy successfully.

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

after apply all these steps i am able to deployed analysis services.

thanks

AVNISH KUMAR SHARMA

|||

Hi

Thanks a million. I shall try it and let you know. very much appreciated.

regards Steve

|||

Hi

You were spot on.. Thanks ever so much for your help. It worked. :)

For others folks...re point 2 in Avnish's note. He is referring to the login id of the machine that hosts SQL Server.

In my case it was Adminstrator.

regards Steve

|||

Hi AVNISH

Thanks very much. That solved the problem. Very much appreciated.

regards Steve

|||

Still I am facing the same problem.

Create my login account mean ?

|||

Hi Stefaan,

Still i am facing the same problem. can you help me out.

i have done the following steps:

=======================

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

I have server name : EZ\SQLExpress and i have created login for ramki i.e. EZ\Ramki and pointed to adventurework database too

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Please can you help me out.

Regards

Ramki

|||

Ramki

Firstly go to Start, SQL Server 2005/Express and then goto 'configuration tools'

Click on the SQL Server Browser and then right click to bring up the context menu and select PROPERTIES.

Ensure that "Built-in Account" is set to local system.

Then

USE any Login with sysadmin rights for AdventureworksDW or (Create any SQL Server Login using MASTER).

Now if you are working standalone you may have another ID to use such as sa. I prefer NOT to use sa for obvious reasons.

If you choose to create a new Login ID, it too MUST have SYSADMIN rights.

Change databases to AdventureworksDW and now 'attach' i.e. add the login to the database.

I am running under windows 2003 server and therefore utilize windows authentication and have an ID in SQL Server 2005 called 'Administrator' which has been allocated sysadmin rights and has sysadmin rights on database AdventureworksDW.

The important thing is that the ID has sysadmin rights in the database that you are trying to connect to.

In this case AdventureworksDW.

THEN

Within your Visual Studio 2005 environment (where you created your project and where you created a data source to link to the ADVENTUREWORKSDW database),double click on the DataSource (in your Solution Explorer) and select the "Impersonation Tab". Select the "Use the Service Account".

This should be all that you need to do. It worked for me.

I hope that this helps.

|||

Hi All,

I tried all that is mentioned in this thread but still facing the problem.

The error

Error 1 The project could not be deployed to the '172.24.185.73\SQL2K5' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

1. SQL Browser service is running under local system account and tried after restarting as well.

2. New Login created (with Sysadmin) on my database using Administrator win account

3. All the settings done mentioned above under impersonation tab

4. Built in Account is set to Local Account.

Any idea/suggestion would be of great help.

Thank

Atgos

|||

Hi Atgos

When I posted my solution I was working with SQL Server 2005 Standard Edition on Windows 2003 Server.

Are you by any chance using Vista?

This is what I did and did you remember the impersonation?

1) Change the SQL server Browser service fAccount to Local System Account

2) Login: sa is fine as long as it has sysadmin rights.

From within Visual Studio .NET 2005 ensure ....

3) Double click on "AdventureWork.ds" from DataSource (From Solution Explorer).
and in Impersonation Information Select the Use the Service Account.

Please let us know how you fare

Can''t Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

Have just installed June CTP on a new laptop build and am having problems getting the AdventureWorks AS database deployed. Using a named instance of SQL Server 2005 (which houses the AdventureWorksDW database) and a named instance of Analysis Services 2005 (which should be getting the deployed database).

After opening the sample solution in BIDS, I changed the data source definition to point to my SQL Server 2005 instance (laptop\sql2005). Tested fine. Then modified the project properties to use the Analysis Services 2005 instance as the deployment location (also laptop\sql2005). Everything looks fine, but when I try to deploy, I get the following three errors:

Error 1: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'localhost' server.

Error 2: Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'localhost' server.

Error 3: Either a connection cannot be made to the localhost\SQL2005 server, or Analysis Services is not running on the computer specified.

So, it looks as if the deployment process is somehow trying to connect to "localhost" instead of my machine name and it also seems as if there's a problem with the SQLBrowser service. I've checked and the service is running.

Probably something silly that I'm either forgetting or overlooking. Anyone?

Thanks,
Dave Fackler
Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler
|||Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler wrote:

Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler

|||I was having the same problem yesterday and found that the Analysis Services service was stopped. No idea on how, but after starting it my connection-related deployment problem went away.|||

Wolfgang W. wrote:

Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler

|||

Just out of curiosity has anyone resolved this one as I have the same problem with NO MINING.

regards Steve

|||

Hi,

I also faced same issue while trying to deploying AdvantureWords Analysis service.

I changed the following setting and after that i am able to deploy successfully.

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

after apply all these steps i am able to deployed analysis services.

thanks

AVNISH KUMAR SHARMA

|||

Hi

Thanks a million. I shall try it and let you know. very much appreciated.

regards Steve

|||

Hi

You were spot on.. Thanks ever so much for your help. It worked. :)

For others folks...re point 2 in Avnish's note. He is referring to the login id of the machine that hosts SQL Server.

In my case it was Adminstrator.

regards Steve

|||

Hi AVNISH

Thanks very much. That solved the problem. Very much appreciated.

regards Steve

|||

Still I am facing the same problem.

Create my login account mean ?

|||

Hi Stefaan,

Still i am facing the same problem. can you help me out.

i have done the following steps:

=======================

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

I have server name : EZ\SQLExpress and i have created login for ramki i.e. EZ\Ramki and pointed to adventurework database too

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Please can you help me out.

Regards

Ramki

|||

Ramki

Firstly go to Start, SQL Server 2005/Express and then goto 'configuration tools'

Click on the SQL Server Browser and then right click to bring up the context menu and select PROPERTIES.

Ensure that "Built-in Account" is set to local system.

Then

USE any Login with sysadmin rights for AdventureworksDW or (Create any SQL Server Login using MASTER).

Now if you are working standalone you may have another ID to use such as sa. I prefer NOT to use sa for obvious reasons.

If you choose to create a new Login ID, it too MUST have SYSADMIN rights.

Change databases to AdventureworksDW and now 'attach' i.e. add the login to the database.

I am running under windows 2003 server and therefore utilize windows authentication and have an ID in SQL Server 2005 called 'Administrator' which has been allocated sysadmin rights and has sysadmin rights on database AdventureworksDW.

The important thing is that the ID has sysadmin rights in the database that you are trying to connect to.

In this case AdventureworksDW.

THEN

Within your Visual Studio 2005 environment (where you created your project and where you created a data source to link to the ADVENTUREWORKSDW database),double click on the DataSource (in your Solution Explorer) and select the "Impersonation Tab". Select the "Use the Service Account".

This should be all that you need to do. It worked for me.

I hope that this helps.

|||

Hi All,

I tried all that is mentioned in this thread but still facing the problem.

The error

Error 1 The project could not be deployed to the '172.24.185.73\SQL2K5' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

1. SQL Browser service is running under local system account and tried after restarting as well.

2. New Login created (with Sysadmin) on my database using Administrator win account

3. All the settings done mentioned above under impersonation tab

4. Built in Account is set to Local Account.

Any idea/suggestion would be of great help.

Thank

Atgos

|||

Hi Atgos

When I posted my solution I was working with SQL Server 2005 Standard Edition on Windows 2003 Server.

Are you by any chance using Vista?

This is what I did and did you remember the impersonation?

1) Change the SQL server Browser service fAccount to Local System Account

2) Login: sa is fine as long as it has sysadmin rights.

From within Visual Studio .NET 2005 ensure ....

3) Double click on "AdventureWork.ds" from DataSource (From Solution Explorer).
and in Impersonation Information Select the Use the Service Account.

Please let us know how you fare

Can''t Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

Have just installed June CTP on a new laptop build and am having problems getting the AdventureWorks AS database deployed. Using a named instance of SQL Server 2005 (which houses the AdventureWorksDW database) and a named instance of Analysis Services 2005 (which should be getting the deployed database).

After opening the sample solution in BIDS, I changed the data source definition to point to my SQL Server 2005 instance (laptop\sql2005). Tested fine. Then modified the project properties to use the Analysis Services 2005 instance as the deployment location (also laptop\sql2005). Everything looks fine, but when I try to deploy, I get the following three errors:

Error 1: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'localhost' server.

Error 2: Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'localhost' server.

Error 3: Either a connection cannot be made to the localhost\SQL2005 server, or Analysis Services is not running on the computer specified.

So, it looks as if the deployment process is somehow trying to connect to "localhost" instead of my machine name and it also seems as if there's a problem with the SQLBrowser service. I've checked and the service is running.

Probably something silly that I'm either forgetting or overlooking. Anyone?

Thanks,
Dave Fackler
Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler
|||Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler wrote:

Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler

|||I was having the same problem yesterday and found that the Analysis Services service was stopped. No idea on how, but after starting it my connection-related deployment problem went away.|||

Wolfgang W. wrote:

Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler

|||

Just out of curiosity has anyone resolved this one as I have the same problem with NO MINING.

regards Steve

|||

Hi,

I also faced same issue while trying to deploying AdvantureWords Analysis service.

I changed the following setting and after that i am able to deploy successfully.

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

after apply all these steps i am able to deployed analysis services.

thanks

AVNISH KUMAR SHARMA

|||

Hi

Thanks a million. I shall try it and let you know. very much appreciated.

regards Steve

|||

Hi

You were spot on.. Thanks ever so much for your help. It worked. :)

For others folks...re point 2 in Avnish's note. He is referring to the login id of the machine that hosts SQL Server.

In my case it was Adminstrator.

regards Steve

|||

Hi AVNISH

Thanks very much. That solved the problem. Very much appreciated.

regards Steve

|||

Still I am facing the same problem.

Create my login account mean ?

|||

Hi Stefaan,

Still i am facing the same problem. can you help me out.

i have done the following steps:

=======================

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

I have server name : EZ\SQLExpress and i have created login for ramki i.e. EZ\Ramki and pointed to adventurework database too

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Please can you help me out.

Regards

Ramki

|||

Ramki

Firstly go to Start, SQL Server 2005/Express and then goto 'configuration tools'

Click on the SQL Server Browser and then right click to bring up the context menu and select PROPERTIES.

Ensure that "Built-in Account" is set to local system.

Then

USE any Login with sysadmin rights for AdventureworksDW or (Create any SQL Server Login using MASTER).

Now if you are working standalone you may have another ID to use such as sa. I prefer NOT to use sa for obvious reasons.

If you choose to create a new Login ID, it too MUST have SYSADMIN rights.

Change databases to AdventureworksDW and now 'attach' i.e. add the login to the database.

I am running under windows 2003 server and therefore utilize windows authentication and have an ID in SQL Server 2005 called 'Administrator' which has been allocated sysadmin rights and has sysadmin rights on database AdventureworksDW.

The important thing is that the ID has sysadmin rights in the database that you are trying to connect to.

In this case AdventureworksDW.

THEN

Within your Visual Studio 2005 environment (where you created your project and where you created a data source to link to the ADVENTUREWORKSDW database),double click on the DataSource (in your Solution Explorer) and select the "Impersonation Tab". Select the "Use the Service Account".

This should be all that you need to do. It worked for me.

I hope that this helps.

|||

Hi All,

I tried all that is mentioned in this thread but still facing the problem.

The error

Error 1 The project could not be deployed to the '172.24.185.73\SQL2K5' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

1. SQL Browser service is running under local system account and tried after restarting as well.

2. New Login created (with Sysadmin) on my database using Administrator win account

3. All the settings done mentioned above under impersonation tab

4. Built in Account is set to Local Account.

Any idea/suggestion would be of great help.

Thank

Atgos

|||

Hi Atgos

When I posted my solution I was working with SQL Server 2005 Standard Edition on Windows 2003 Server.

Are you by any chance using Vista?

This is what I did and did you remember the impersonation?

1) Change the SQL server Browser service fAccount to Local System Account

2) Login: sa is fine as long as it has sysadmin rights.

From within Visual Studio .NET 2005 ensure ....

3) Double click on "AdventureWork.ds" from DataSource (From Solution Explorer).
and in Impersonation Information Select the Use the Service Account.

Please let us know how you fare

Can't Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

Have just installed June CTP on a new laptop build and am having problems getting the AdventureWorks AS database deployed. Using a named instance of SQL Server 2005 (which houses the AdventureWorksDW database) and a named instance of Analysis Services 2005 (which should be getting the deployed database).

After opening the sample solution in BIDS, I changed the data source definition to point to my SQL Server 2005 instance (laptop\sql2005). Tested fine. Then modified the project properties to use the Analysis Services 2005 instance as the deployment location (also laptop\sql2005). Everything looks fine, but when I try to deploy, I get the following three errors:

Error 1: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'localhost' server.

Error 2: Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'localhost' server.

Error 3: Either a connection cannot be made to the localhost\SQL2005 server, or Analysis Services is not running on the computer specified.

So, it looks as if the deployment process is somehow trying to connect to "localhost" instead of my machine name and it also seems as if there's a problem with the SQLBrowser service. I've checked and the service is running.

Probably something silly that I'm either forgetting or overlooking. Anyone?

Thanks,
Dave Fackler
Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler
|||Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler wrote:

Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler

|||I was having the same problem yesterday and found that the Analysis Services service was stopped. No idea on how, but after starting it my connection-related deployment problem went away.|||

Wolfgang W. wrote:

Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler

|||

Just out of curiosity has anyone resolved this one as I have the same problem with NO MINING.

regards Steve

|||

Hi,

I also faced same issue while trying to deploying AdvantureWords Analysis service.

I changed the following setting and after that i am able to deploy successfully.

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

after apply all these steps i am able to deployed analysis services.

thanks

AVNISH KUMAR SHARMA

|||

Hi

Thanks a million. I shall try it and let you know. very much appreciated.

regards Steve

|||

Hi

You were spot on.. Thanks ever so much for your help. It worked. :)

For others folks...re point 2 in Avnish's note. He is referring to the login id of the machine that hosts SQL Server.

In my case it was Adminstrator.

regards Steve

|||

Hi AVNISH

Thanks very much. That solved the problem. Very much appreciated.

regards Steve

|||

Still I am facing the same problem.

Create my login account mean ?

|||

Hi Stefaan,

Still i am facing the same problem. can you help me out.

i have done the following steps:

=======================

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

I have server name : EZ\SQLExpress and i have created login for ramki i.e. EZ\Ramki and pointed to adventurework database too

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Please can you help me out.

Regards

Ramki

|||

Ramki

Firstly go to Start, SQL Server 2005/Express and then goto 'configuration tools'

Click on the SQL Server Browser and then right click to bring up the context menu and select PROPERTIES.

Ensure that "Built-in Account" is set to local system.

Then

USE any Login with sysadmin rights for AdventureworksDW or (Create any SQL Server Login using MASTER).

Now if you are working standalone you may have another ID to use such as sa. I prefer NOT to use sa for obvious reasons.

If you choose to create a new Login ID, it too MUST have SYSADMIN rights.

Change databases to AdventureworksDW and now 'attach' i.e. add the login to the database.

I am running under windows 2003 server and therefore utilize windows authentication and have an ID in SQL Server 2005 called 'Administrator' which has been allocated sysadmin rights and has sysadmin rights on database AdventureworksDW.

The important thing is that the ID has sysadmin rights in the database that you are trying to connect to.

In this case AdventureworksDW.

THEN

Within your Visual Studio 2005 environment (where you created your project and where you created a data source to link to the ADVENTUREWORKSDW database),double click on the DataSource (in your Solution Explorer) and select the "Impersonation Tab". Select the "Use the Service Account".

This should be all that you need to do. It worked for me.

I hope that this helps.

|||

Hi All,

I tried all that is mentioned in this thread but still facing the problem.

The error

Error 1 The project could not be deployed to the '172.24.185.73\SQL2K5' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

1. SQL Browser service is running under local system account and tried after restarting as well.

2. New Login created (with Sysadmin) on my database using Administrator win account

3. All the settings done mentioned above under impersonation tab

4. Built in Account is set to Local Account.

Any idea/suggestion would be of great help.

Thank

Atgos

Can't Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

Have just installed June CTP on a new laptop build and am having problems getting the AdventureWorks AS database deployed. Using a named instance of SQL Server 2005 (which houses the AdventureWorksDW database) and a named instance of Analysis Services 2005 (which should be getting the deployed database).

After opening the sample solution in BIDS, I changed the data source definition to point to my SQL Server 2005 instance (laptop\sql2005). Tested fine. Then modified the project properties to use the Analysis Services 2005 instance as the deployment location (also laptop\sql2005). Everything looks fine, but when I try to deploy, I get the following three errors:

Error 1: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'localhost' server.

Error 2: Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'localhost' server.

Error 3: Either a connection cannot be made to the localhost\SQL2005 server, or Analysis Services is not running on the computer specified.

So, it looks as if the deployment process is somehow trying to connect to "localhost" instead of my machine name and it also seems as if there's a problem with the SQLBrowser service. I've checked and the service is running.

Probably something silly that I'm either forgetting or overlooking. Anyone?

Thanks,
Dave FacklerJust to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler|||Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler wrote:

Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler

|||I was having the same problem yesterday and found that the Analysis Services service was stopped. No idea on how, but after starting it my connection-related deployment problem went away.|||

Wolfgang W. wrote:

Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler

|||

Just out of curiosity has anyone resolved this one as I have the same problem with NO MINING.

regards Steve

|||

Hi,

I also faced same issue while trying to deploying AdvantureWords Analysis service.

I changed the following setting and after that i am able to deploy successfully.

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

after apply all these steps i am able to deployed analysis services.

thanks

AVNISH KUMAR SHARMA

|||

Hi

Thanks a million. I shall try it and let you know. very much appreciated.

regards Steve

|||

Hi

You were spot on.. Thanks ever so much for your help. It worked. :)

For others folks...re point 2 in Avnish's note. He is referring to the login id of the machine that hosts SQL Server.

In my case it was Adminstrator.

regards Steve

|||

Hi AVNISH

Thanks very much. That solved the problem. Very much appreciated.

regards Steve

|||

Still I am facing the same problem.

Create my login account mean ?

|||

Hi Stefaan,

Still i am facing the same problem. can you help me out.

i have done the following steps:

=======================

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

I have server name : EZ\SQLExpress and i have created login for ramki i.e. EZ\Ramki and pointed to adventurework database too

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Please can you help me out.

Regards

Ramki

|||

Ramki

Firstly go to Start, SQL Server 2005/Express and then goto 'configuration tools'

Click on the SQL Server Browser and then right click to bring up the context menu and select PROPERTIES.

Ensure that "Built-in Account" is set to local system.

Then

USE any Login with sysadmin rights for AdventureworksDW or (Create any SQL Server Login using MASTER).

Now if you are working standalone you may have another ID to use such as sa. I prefer NOT to use sa for obvious reasons.

If you choose to create a new Login ID, it too MUST have SYSADMIN rights.

Change databases to AdventureworksDW and now 'attach' i.e. add the login to the database.

I am running under windows 2003 server and therefore utilize windows authentication and have an ID in SQL Server 2005 called 'Administrator' which has been allocated sysadmin rights and has sysadmin rights on database AdventureworksDW.

The important thing is that the ID has sysadmin rights in the database that you are trying to connect to.

In this case AdventureworksDW.

THEN

Within your Visual Studio 2005 environment (where you created your project and where you created a data source to link to the ADVENTUREWORKSDW database),double click on the DataSource (in your Solution Explorer) and select the "Impersonation Tab". Select the "Use the Service Account".

This should be all that you need to do. It worked for me.

I hope that this helps.

Can't Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

Have just installed June CTP on a new laptop build and am having problems getting the AdventureWorks AS database deployed. Using a named instance of SQL Server 2005 (which houses the AdventureWorksDW database) and a named instance of Analysis Services 2005 (which should be getting the deployed database).

After opening the sample solution in BIDS, I changed the data source definition to point to my SQL Server 2005 instance (laptop\sql2005). Tested fine. Then modified the project properties to use the Analysis Services 2005 instance as the deployment location (also laptop\sql2005). Everything looks fine, but when I try to deploy, I get the following three errors:

Error 1: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'localhost' server.

Error 2: Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'localhost' server.

Error 3: Either a connection cannot be made to the localhost\SQL2005 server, or Analysis Services is not running on the computer specified.

So, it looks as if the deployment process is somehow trying to connect to "localhost" instead of my machine name and it also seems as if there's a problem with the SQLBrowser service. I've checked and the service is running.

Probably something silly that I'm either forgetting or overlooking. Anyone?

Thanks,
Dave Fackler
Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler
|||Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler wrote:

Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler

|||I was having the same problem yesterday and found that the Analysis Services service was stopped. No idea on how, but after starting it my connection-related deployment problem went away.|||

Wolfgang W. wrote:

Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler

|||

Just out of curiosity has anyone resolved this one as I have the same problem with NO MINING.

regards Steve

|||

Hi,

I also faced same issue while trying to deploying AdvantureWords Analysis service.

I changed the following setting and after that i am able to deploy successfully.

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

after apply all these steps i am able to deployed analysis services.

thanks

AVNISH KUMAR SHARMA

|||

Hi

Thanks a million. I shall try it and let you know. very much appreciated.

regards Steve

|||

Hi

You were spot on.. Thanks ever so much for your help. It worked. :)

For others folks...re point 2 in Avnish's note. He is referring to the login id of the machine that hosts SQL Server.

In my case it was Adminstrator.

regards Steve

|||

Hi AVNISH

Thanks very much. That solved the problem. Very much appreciated.

regards Steve

|||

Still I am facing the same problem.

Create my login account mean ?

|||

Hi Stefaan,

Still i am facing the same problem. can you help me out.

i have done the following steps:

=======================

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

I have server name : EZ\SQLExpress and i have created login for ramki i.e. EZ\Ramki and pointed to adventurework database too

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Please can you help me out.

Regards

Ramki

|||

Ramki

Firstly go to Start, SQL Server 2005/Express and then goto 'configuration tools'

Click on the SQL Server Browser and then right click to bring up the context menu and select PROPERTIES.

Ensure that "Built-in Account" is set to local system.

Then

USE any Login with sysadmin rights for AdventureworksDW or (Create any SQL Server Login using MASTER).

Now if you are working standalone you may have another ID to use such as sa. I prefer NOT to use sa for obvious reasons.

If you choose to create a new Login ID, it too MUST have SYSADMIN rights.

Change databases to AdventureworksDW and now 'attach' i.e. add the login to the database.

I am running under windows 2003 server and therefore utilize windows authentication and have an ID in SQL Server 2005 called 'Administrator' which has been allocated sysadmin rights and has sysadmin rights on database AdventureworksDW.

The important thing is that the ID has sysadmin rights in the database that you are trying to connect to.

In this case AdventureworksDW.

THEN

Within your Visual Studio 2005 environment (where you created your project and where you created a data source to link to the ADVENTUREWORKSDW database),double click on the DataSource (in your Solution Explorer) and select the "Impersonation Tab". Select the "Use the Service Account".

This should be all that you need to do. It worked for me.

I hope that this helps.

Can't Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

Have just installed June CTP on a new laptop build and am having problems getting the AdventureWorks AS database deployed. Using a named instance of SQL Server 2005 (which houses the AdventureWorksDW database) and a named instance of Analysis Services 2005 (which should be getting the deployed database).

After opening the sample solution in BIDS, I changed the data source definition to point to my SQL Server 2005 instance (laptop\sql2005). Tested fine. Then modified the project properties to use the Analysis Services 2005 instance as the deployment location (also laptop\sql2005). Everything looks fine, but when I try to deploy, I get the following three errors:

Error 1: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'localhost' server.

Error 2: Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'localhost' server.

Error 3: Either a connection cannot be made to the localhost\SQL2005 server, or Analysis Services is not running on the computer specified.

So, it looks as if the deployment process is somehow trying to connect to "localhost" instead of my machine name and it also seems as if there's a problem with the SQLBrowser service. I've checked and the service is running.

Probably something silly that I'm either forgetting or overlooking. Anyone?

Thanks,
Dave FacklerJust to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler|||Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler wrote:

Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.

Dave Fackler

|||I was having the same problem yesterday and found that the Analysis Services service was stopped. No idea on how, but after starting it my connection-related deployment problem went away.|||

Wolfgang W. wrote:

Hi,

I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:

"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0"

There are no data mining objects in my project. I modified already the deployment properties in the project.

Best regards,
Wolfgang

Dave Fackler

|||

Just out of curiosity has anyone resolved this one as I have the same problem with NO MINING.

regards Steve

|||

Hi,

I also faced same issue while trying to deploying AdvantureWords Analysis service.

I changed the following setting and after that i am able to deploy successfully.

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

after apply all these steps i am able to deployed analysis services.

thanks

AVNISH KUMAR SHARMA

|||

Hi

Thanks a million. I shall try it and let you know. very much appreciated.

regards Steve

|||

Hi

You were spot on.. Thanks ever so much for your help. It worked. :)

For others folks...re point 2 in Avnish's note. He is referring to the login id of the machine that hosts SQL Server.

In my case it was Adminstrator.

regards Steve

|||

Hi AVNISH

Thanks very much. That solved the problem. Very much appreciated.

regards Steve

|||

Still I am facing the same problem.

Create my login account mean ?

|||

Hi Stefaan,

Still i am facing the same problem. can you help me out.

i have done the following steps:

=======================

1) Change the SQL server Browser service running Account to Local System Account

2) Create My Login Account in SQL >Security->Login

I have server name : EZ\SQLExpress and i have created login for ramki i.e. EZ\Ramki and pointed to adventurework database too

3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Please can you help me out.

Regards

Ramki

|||

Ramki

Firstly go to Start, SQL Server 2005/Express and then goto 'configuration tools'

Click on the SQL Server Browser and then right click to bring up the context menu and select PROPERTIES.

Ensure that "Built-in Account" is set to local system.

Then

USE any Login with sysadmin rights for AdventureworksDW or (Create any SQL Server Login using MASTER).

Now if you are working standalone you may have another ID to use such as sa. I prefer NOT to use sa for obvious reasons.

If you choose to create a new Login ID, it too MUST have SYSADMIN rights.

Change databases to AdventureworksDW and now 'attach' i.e. add the login to the database.

I am running under windows 2003 server and therefore utilize windows authentication and have an ID in SQL Server 2005 called 'Administrator' which has been allocated sysadmin rights and has sysadmin rights on database AdventureworksDW.

The important thing is that the ID has sysadmin rights in the database that you are trying to connect to.

In this case AdventureworksDW.

THEN

Within your Visual Studio 2005 environment (where you created your project and where you created a data source to link to the ADVENTUREWORKSDW database),double click on the DataSource (in your Solution Explorer) and select the "Impersonation Tab". Select the "Use the Service Account".

This should be all that you need to do. It worked for me.

I hope that this helps.

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
The client is attempting to connect using TCP/IP so you will
want to make sure this protocol is enabled for MSDE. You can
use the server network utility to check, enable the
protocols. The utility file name is svrnetcn.exe. You can
find it in the Tools\Binn directory of your installation
path.
You can also find some general troubleshooting for the error
at:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On Sun, 2 May 2004 16:00:49 -0500, "Sal Young"
<salyoung@.comcast.net> wrote:

>I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
>a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
>firewall to connect the two computers and I'm getting the following error:
>Unable to connec to server SERVERNAME
>Server: Msg 17, Level 16, State1
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
>access denied
>
>I've tried by creating a new account with owner rights to all databases and
>I still get the same error when connecting with Query Analyzer. When I get
>the "Connect to SQL Server" dialog box I can see the server but when I enter
>the user name an password it gives me the error message.
>

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.Hi Sal,
Try creating a Test ODBC DSN to the MSDE server. Then review the OS
Error returned.
This will help troubleshoot the problem.
Example:
10060 = Connection Timeout
11001 = Host not found.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
MSDE doesn't listen to any netlibs by default. You can enable netlibs using the svrnetcn.exe utility.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Sal Young" <salyoung@.comcast.net> wrote in message news:MMadnZ23tfPw_AjdRVn-sA@.comcast.com...
> I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
> a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
> firewall to connect the two computers and I'm getting the following error:
> Unable to connec to server SERVERNAME
> Server: Msg 17, Level 16, State1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied
>
> I've tried by creating a new account with owner rights to all databases and
> I still get the same error when connecting with Query Analyzer. When I get
> the "Connect to SQL Server" dialog box I can see the server but when I enter
> the user name an password it gives me the error message.
>

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
Hi Sal,
Try creating a Test ODBC DSN to the MSDE server. Then review the OS
Error returned.
This will help troubleshoot the problem.
Example:
10060 = Connection Timeout
11001 = Host not found.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

can't connect to the ODBC database named aspol54

can any one provide any suggestions to help this error i installed automation studion 5.4 and the program will not run on my laptop.

i traced the data below when i try to start the program.

AsProjet db0-b5c ENTER SQLAllocEnv
HENV * 015CF6B0

AsProjet db0-b5c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x015CF6B0 ( 0x015e1540)

AsProjet db0-b5c ENTER SQLGetEnvAttr
SQLHENV 015E1540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0013E380

AsProjet db0-b5c EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 015E1540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0013E380 (1567744)
any help would be great.

tks

I don't know how much help this is, but the '201' attribute is for 'SQL_ATTR_CONNECTION_POOLING'. The weird thing is that the return value seems to be 1567744. It should be returning '0' in this case. Here are possible values (from SQLEXT.H):

/* values for SQL_ATTR_CONNECTION_POOLING */
#define SQL_CP_OFF 0UL
#define SQL_CP_ONE_PER_DRIVER 1UL
#define SQL_CP_ONE_PER_HENV 2UL
#define SQL_CP_DEFAULT SQL_CP_OFF

It looks like you're receiving invalid data, but I don't know why or how. Sorry I can't be of more help.

Perhaps someone else on the alias can shed some light on this?

|||

Hi,

In addition to Warren's comments - what you see in the ODBC trace doesn't indicate an error. Simply an Environment handle was allocated and GetEnvAttr was called to retrieve the Environment's connection pooling attribute setting. Both calls appear to have succeeded. The fact that we get a strange value, probably means that the ODBC driver doesn't support it (it's an ODBC 3.0 attribute). Is the application using the driver directly (without Driver Manager)? Could you post the actual error that you get or is there any additional information in the ODBC trace?

HTH,

Jivko Dobrev - MSFT

---

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

Can't connect to SQL server after hibernating

Hi,
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server
,
such as from Query Analyzer, work fine, but I can not make new connections t
o
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:

>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the serve
r,
>such as from Query Analyzer, work fine, but I can not make new connections
to
>the server. I've tried restarting the server through the SQL Server Servic
e
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the lapto
p
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server d
oes not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about
a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:

> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Even
t
>Viewer in Administrative Tools. There's nothing SQL related in there about
a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
>|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:

> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open fo
r
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out o
f
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
>|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adapto
r
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:

> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adapt
or
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:
>

Can't connect to SQL server after hibernating

Hi,
I currently have a development SQL server running locally on my laptop.
After my laptop comes out of hibernation, existing connections to the server,
such as from Query Analyzer, work fine, but I can not make new connections to
the server. I've tried restarting the server through the SQL Server Service
Manager, but it doesn't solve the problem. The only way to be able to
re-establish a connection is to reboot; which makes developing on the laptop
difficult.
Here is the result of "select @.@.Version":
Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
What exact errors do you get when you can't connect?
Did you check the event logs for errors?
-Sue
On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
Rondeau@.discussions.microsoft.com> wrote:

>Hi,
>I currently have a development SQL server running locally on my laptop.
>After my laptop comes out of hibernation, existing connections to the server,
>such as from Query Analyzer, work fine, but I can not make new connections to
>the server. I've tried restarting the server through the SQL Server Service
>Manager, but it doesn't solve the problem. The only way to be able to
>re-establish a connection is to reboot; which makes developing on the laptop
>difficult.
>Here is the result of "select @.@.Version":
>Microsoft SQL Server 2000 - 8.00.944 (Intel X86) May 19 2004 18:32:44
>Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)
|||The error message that I'm getting (from SQL Query Analyzer) is:
"Unable to connect to server [my laptop's server name]"
"Server: Msg 17, Level 16, State 1"
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied."
With regard to the event log, I'm assuming that you're refering to the Event
Viewer in Administrative Tools. There's nothing SQL related in there about a
connection failure.
Again, an existing connection in SQL Query Analyzer runs fine.
"Sue Hoegemeier" wrote:

> What exact errors do you get when you can't connect?
> Did you check the event logs for errors?
> -Sue
> On Wed, 12 Oct 2005 11:21:09 -0700, Andy Rondeau <Andy
> Rondeau@.discussions.microsoft.com> wrote:
>
>
|||Could be your NIC - they can switch off in hibernation mode.
Try to telnet to the listening port.
Yes...the Event viewer displays the event logs. I'd look for
network, networking component related issues, not
necessarily just SQL errors related to connection failure.
-Sue
On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The error message that I'm getting (from SQL Query Analyzer) is:
>"Unable to connect to server [my laptop's server name]"
>"Server: Msg 17, Level 16, State 1"
>"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
>exist or access denied."
>With regard to the event log, I'm assuming that you're refering to the Event
>Viewer in Administrative Tools. There's nothing SQL related in there about a
>connection failure.
>Again, an existing connection in SQL Query Analyzer runs fine.
>"Sue Hoegemeier" wrote:
|||When I telnet into the server, it connects and the connection stays open for
about a second, and then the connection breaks.
With regard to networking events in the event log, there's some generic
adaptor connected / disconnected around the time that I went into and out of
hibernation, but nothing that would indicate that the adaptor shut down.
"Sue Hoegemeier" wrote:

> Could be your NIC - they can switch off in hibernation mode.
> Try to telnet to the listening port.
> Yes...the Event viewer displays the event logs. I'd look for
> network, networking component related issues, not
> necessarily just SQL errors related to connection failure.
> -Sue
> On Mon, 17 Oct 2005 18:28:02 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>
|||They don't always come back very well once disconnected so I
would really suspect it has something to do with that.
-Sue
On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I telnet into the server, it connects and the connection stays open for
>about a second, and then the connection breaks.
>With regard to networking events in the event log, there's some generic
>adaptor connected / disconnected around the time that I went into and out of
>hibernation, but nothing that would indicate that the adaptor shut down.
>"Sue Hoegemeier" wrote:
|||But that doesn't solve my problem. I AM making a successful, but short,
connection in telnet after a hibernation, which means that my network adaptor
is not the culprit.
Is there some way of restarting the SQL server so that it'll accept
connections? Could this be an issue with the client?
"Sue Hoegemeier" wrote:

> They don't always come back very well once disconnected so I
> would really suspect it has something to do with that.
> -Sue
> On Tue, 18 Oct 2005 12:20:08 -0700, Andy Rondeau
> <AndyRondeau@.discussions.microsoft.com> wrote:
>
>
|||I just wouldn't use hibernate with SQL Server running. I
wouldn't trust it with SQL anyway
-Sue
On Wed, 19 Oct 2005 10:20:01 -0700, Andy Rondeau
<AndyRondeau@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>But that doesn't solve my problem. I AM making a successful, but short,
>connection in telnet after a hibernation, which means that my network adaptor
>is not the culprit.
>Is there some way of restarting the SQL server so that it'll accept
>connections? Could this be an issue with the client?
>"Sue Hoegemeier" wrote:

Can't connect to SQL Express 2005

I have a web app running on a laptop (for demo purposes) with the following connect string:

"datasource=<machine name>\SQLExpress;initial catalog=BlueTarp;User ID=sa;Password=xxx"

I can connect to this instance using both oSQL or sqlcmd and can select from the tables within BlueTarp, but my web app won't connect, and I can't figure out why!!

When I installed SQL Express, I used a named instance, called "SQLExpress".

I'm using mixed mode authentication.

One strange thing is that I can connect to either SQLExpress or MSSQLSERVER instances, but they appear to be the same instance -- I can use bluetarp in both.

when I use SQLExpress for instance name in web.config I get "SQL Server does not exist or access denied"

when I use MSSQLServer for instance name in web.config I get "Invalid connection"

And in fiddling with the web.config, I somehow did something to get a machine.config error, something like "machine.config couldn't be loaded because of an unloaded appdomain".

It's driving me nuts because I've spent a good 40 hours on this stupid problem, throwing the whole margin down the toilet.

Does anyone have any ideas?

Thank you,

Aarron

First, SQL Server has support for multiple protocols for remote connections (shared memory, named pipes, tcp/ip, and via) and if the client is trying a protocol the server has disabled then it will fail to connect.

To see what protocols are enabled, goto Computer Management -> SQL Server Configuration Manager -> SQL Server 2005 Network Configuration -> Protocols for <Instance Name>. If you change the protocols the server supports, you will need to restart the server.

Try using a protocol such as named pipes instead of shared memory. Try np:<machine name>.

http://msdn2.microsoft.com/en-US/library/system.data.sqlclient.sqlconnection.connectionstring(VS.80).aspx

For general troubleshooting of .NET connectivity issues, see this blog entry: http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

For the ASP.NET issue, try restarting IIS/ASP.NET, and make sure machine.config is valid xml with the XML editor in Visual Studio.

|||

Mark,

Thanks so much for your help. I've been all over the web trying to find info about this problem -- people have pointed me to Mcaffe, to the .NET frameworks possibly having issues, to my web.config being poorly formatted.... and it turns out that I wasn't using a supported protocol. I enabled named pipes and it works like a charm.

You da man!

Aarron

Can't connect to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
To start with, run the following command using ISQL.exe
ISQL -Stcp:ServerNameHere -Usa -Ppassword -Q"select @.@.version"
The reason why I am asking you to do this is because this will help you in
troubleshooting the error. Try looking for the OS Error returned.
I am suspecting that the server is not listening on the port and you can
try to restart MSSQLServer and can verify that SQL is listening. Hope this
helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Can't connect to local instance

Hi,

SQL Server 2005 Developer edition Windows XP Pro
This is a new install on this laptop. Trying to connect to the Database Engine using management studio using either TCP/IP or named pipes but getting errors regarding the server refusing connection. I've Googled these errors and as far as I can see I made all the adjustments that I need to.

TCP/IP
An error has occurred while establishing a connection to the server. 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. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

Named Pipes
An error has occurred while establishing a connection to the server. 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

I've opened up both protocols in the Configuration Manager and I've opened up local and remote connections to both protocols in surface area configurator. Even tried this with the windows firewall switched off.

Any suggestions anyone?

Thanks
DaveAfter installation, did you check if the services are running?|||Yep, in fact I restarted most of them to be sure. This laptop briefly had SQL 2005 Express on it a while ago and even though that software has been removed the machine still thinks it has an instance installed.

Is it an issue to have a DHCP assigned IP address when using SQL 2005?

Dave|||

No I don't think as my laptop is with similar configuration and have no issues in connecting to the SQL instances.

Make sure SQL Browser service is up and running. Refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx on Performing Configuration Changes topic.

HTH

york001 wrote:

Is it an issue to have a DHCP assigned IP address when using SQL 2005?

Dave

Can''t connect in Sql Express on local machine

I have SQL Express running on my laptop but are unable to connect to the default database paulm-laptop\sqlexpress

When I try to connect I get the error message

TITLE: Microsoft SQL Server Management Studio Express
An error has occurred while establishing a connection to the server. 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Everything is on my laptop whcih is running Vista Business as an administrator

Any ideas why,

Thanks Paul

Did you enable remote connections for your SQL Server Instance ? If not, have a look at my screencast for more information how to do this.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Since you are on Vista, you should make sure that you are running Managment Studio as Administrator (right click on the shortcut and on Compatibility, choose Run as Administrator) or you can just right click on the shortcut and choose Run as Administrator each time you run it. I have seen this error when running it without it.