I am working with SQL Server 2005 Express installed on my workstation under
XP SP2.
I am trying to work through the online tutorial. I am on
http://msdn2.microsoft.com/en-us/library/ms170681.aspx
I downloaded the AdventureWorksDB.msi and installed it. The files
AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
I am now trying to register the AdventureWorks server. Everything looks as
described in the tutorial until I get to the Connection Properties in Step 5.
There are no options for me to select. There are no databases other than
the initial system databases (no User Databases) when I try to browse.
Did I do something wrong? How do I locate the database so I can register it?Ensure you attached the AdventureWorks database to your SQL Server instance
which you choose in the New Server Registration window as the Server Name
editbox (e.g. EKREM-PC\test2)
If the AdventureWorks database is attached to your SQL Server instance and
if you type this SQL Server instance' s name in the Server Name editbox in
the New Server Registration, then you should be seeing the AdventureWorks
database in the combobox in Connection Properties tab in the New Server
Registration window.
--
Ekrem Ã?nsoy
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>|||"Installing" from the MSI just extracts the database files. You then need
to run CREATE DATABASE ... FOR ATTACH. See Books Online for exact syntax.
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
Showing posts with label adventureworks. Show all posts
Showing posts with label adventureworks. Show all posts
Thursday, March 22, 2012
Can't find AdventureWorks in order to connect
I am working with SQL Server 2005 Express installed on my workstation under
XP SP2.
I am trying to work through the online tutorial. I am on
http://msdn2.microsoft.com/en-us/library/ms170681.aspx
I downloaded the AdventureWorksDB.msi and installed it. The files
AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
I am now trying to register the AdventureWorks server. Everything looks as
described in the tutorial until I get to the Connection Properties in Step 5.
There are no options for me to select. There are no databases other than
the initial system databases (no User Databases) when I try to browse.
Did I do something wrong? How do I locate the database so I can register it?
Ensure you attached the AdventureWorks database to your SQL Server instance
which you choose in the New Server Registration window as the Server Name
editbox (e.g. EKREM-PC\test2)
If the AdventureWorks database is attached to your SQL Server instance and
if you type this SQL Server instance' s name in the Server Name editbox in
the New Server Registration, then you should be seeing the AdventureWorks
database in the combobox in Connection Properties tab in the New Server
Registration window.
Ekrem ?nsoy
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
|||"Installing" from the MSI just extracts the database files. You then need
to run CREATE DATABASE ... FOR ATTACH. See Books Online for exact syntax.
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
sql
XP SP2.
I am trying to work through the online tutorial. I am on
http://msdn2.microsoft.com/en-us/library/ms170681.aspx
I downloaded the AdventureWorksDB.msi and installed it. The files
AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
I am now trying to register the AdventureWorks server. Everything looks as
described in the tutorial until I get to the Connection Properties in Step 5.
There are no options for me to select. There are no databases other than
the initial system databases (no User Databases) when I try to browse.
Did I do something wrong? How do I locate the database so I can register it?
Ensure you attached the AdventureWorks database to your SQL Server instance
which you choose in the New Server Registration window as the Server Name
editbox (e.g. EKREM-PC\test2)
If the AdventureWorks database is attached to your SQL Server instance and
if you type this SQL Server instance' s name in the Server Name editbox in
the New Server Registration, then you should be seeing the AdventureWorks
database in the combobox in Connection Properties tab in the New Server
Registration window.
Ekrem ?nsoy
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
|||"Installing" from the MSI just extracts the database files. You then need
to run CREATE DATABASE ... FOR ATTACH. See Books Online for exact syntax.
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
sql
Can't find AdventureWorks in order to connect
I am working with SQL Server 2005 Express installed on my workstation under
XP SP2.
I am trying to work through the online tutorial. I am on
http://msdn2.microsoft.com/en-us/library/ms170681.aspx
I downloaded the AdventureWorksDB.msi and installed it. The files
AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
I am now trying to register the AdventureWorks server. Everything looks as
described in the tutorial until I get to the Connection Properties in Step 5
.
There are no options for me to select. There are no databases other than
the initial system databases (no User Databases) when I try to browse.
Did I do something wrong? How do I locate the database so I can register it
?Ensure you attached the AdventureWorks database to your SQL Server instance
which you choose in the New Server Registration window as the Server Name
editbox (e.g. EKREM-PC\test2)
If the AdventureWorks database is attached to your SQL Server instance and
if you type this SQL Server instance' s name in the Server Name editbox in
the New Server Registration, then you should be seeing the AdventureWorks
database in the combobox in Connection Properties tab in the New Server
Registration window.
Ekrem ?nsoy
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>|||"Installing" from the MSI just extracts the database files. You then need
to run CREATE DATABASE ... FOR ATTACH. See Books Online for exact syntax.
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
XP SP2.
I am trying to work through the online tutorial. I am on
http://msdn2.microsoft.com/en-us/library/ms170681.aspx
I downloaded the AdventureWorksDB.msi and installed it. The files
AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
I am now trying to register the AdventureWorks server. Everything looks as
described in the tutorial until I get to the Connection Properties in Step 5
.
There are no options for me to select. There are no databases other than
the initial system databases (no User Databases) when I try to browse.
Did I do something wrong? How do I locate the database so I can register it
?Ensure you attached the AdventureWorks database to your SQL Server instance
which you choose in the New Server Registration window as the Server Name
editbox (e.g. EKREM-PC\test2)
If the AdventureWorks database is attached to your SQL Server instance and
if you type this SQL Server instance' s name in the Server Name editbox in
the New Server Registration, then you should be seeing the AdventureWorks
database in the combobox in Connection Properties tab in the New Server
Registration window.
Ekrem ?nsoy
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>|||"Installing" from the MSI just extracts the database files. You then need
to run CREATE DATABASE ... FOR ATTACH. See Books Online for exact syntax.
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
Monday, March 19, 2012
cant download/install adventureworks.sln
HI I have installed the adventure works db scripts and have both the
adventureworks and adventureworksdw databases installed. I am missing the
adventureworks.sln (adventure works project files). I tried to install
adventureworksBI.msi but I got an error that the adventureworks database is
already installed. I tried renaming the adventureworks database on the
server to something else and tried the install again but I got an error
message that it was too old of a version. I am not sure if there is a script
I need to run that will instal the project files, Any ideas? thanks.
--
Paul G
Software engineer.I guess it's about Sql Server Samples. Did you download the latest version
from the following link:
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
After installing it, you'll find the AdventureWorks(VB\CS).sln VS solution
file in the following path:
C:\Program Files\Microsoft SQL
Server\90\Samples\Engine\Programmability\CLR\AdventureWorks
If this is what you are looking for...
--
Ekrem Ã?nsoy
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:31D4B610-532F-4916-9C11-325FC5147444@.microsoft.com...
> HI I have installed the adventure works db scripts and have both the
> adventureworks and adventureworksdw databases installed. I am missing the
> adventureworks.sln (adventure works project files). I tried to install
> adventureworksBI.msi but I got an error that the adventureworks database
> is
> already installed. I tried renaming the adventureworks database on the
> server to something else and tried the install again but I got an error
> message that it was too old of a version. I am not sure if there is a
> script
> I need to run that will instal the project files, Any ideas? thanks.
> --
> Paul G
> Software engineer.|||Thanks for the response, yes I am looking for the solution, I have the
following but there is no sample folder C:\Program Files\Microsoft SQL
Server\90. I downloaded the adventureworksvbscripts and installed both the
adventureworks and adventureworksDW databases. I will try the link provided.
--
Paul G
Software engineer.
"Ekrem Ã?nsoy" wrote:
> I guess it's about Sql Server Samples. Did you download the latest version
> from the following link:
> http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
> After installing it, you'll find the AdventureWorks(VB\CS).sln VS solution
> file in the following path:
> C:\Program Files\Microsoft SQL
> Server\90\Samples\Engine\Programmability\CLR\AdventureWorks
> If this is what you are looking for...
> --
> Ekrem Ã?nsoy
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:31D4B610-532F-4916-9C11-325FC5147444@.microsoft.com...
> > HI I have installed the adventure works db scripts and have both the
> > adventureworks and adventureworksdw databases installed. I am missing the
> > adventureworks.sln (adventure works project files). I tried to install
> > adventureworksBI.msi but I got an error that the adventureworks database
> > is
> > already installed. I tried renaming the adventureworks database on the
> > server to something else and tried the install again but I got an error
> > message that it was too old of a version. I am not sure if there is a
> > script
> > I need to run that will instal the project files, Any ideas? thanks.
> > --
> > Paul G
> > Software engineer.
>
adventureworks and adventureworksdw databases installed. I am missing the
adventureworks.sln (adventure works project files). I tried to install
adventureworksBI.msi but I got an error that the adventureworks database is
already installed. I tried renaming the adventureworks database on the
server to something else and tried the install again but I got an error
message that it was too old of a version. I am not sure if there is a script
I need to run that will instal the project files, Any ideas? thanks.
--
Paul G
Software engineer.I guess it's about Sql Server Samples. Did you download the latest version
from the following link:
http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
After installing it, you'll find the AdventureWorks(VB\CS).sln VS solution
file in the following path:
C:\Program Files\Microsoft SQL
Server\90\Samples\Engine\Programmability\CLR\AdventureWorks
If this is what you are looking for...
--
Ekrem Ã?nsoy
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:31D4B610-532F-4916-9C11-325FC5147444@.microsoft.com...
> HI I have installed the adventure works db scripts and have both the
> adventureworks and adventureworksdw databases installed. I am missing the
> adventureworks.sln (adventure works project files). I tried to install
> adventureworksBI.msi but I got an error that the adventureworks database
> is
> already installed. I tried renaming the adventureworks database on the
> server to something else and tried the install again but I got an error
> message that it was too old of a version. I am not sure if there is a
> script
> I need to run that will instal the project files, Any ideas? thanks.
> --
> Paul G
> Software engineer.|||Thanks for the response, yes I am looking for the solution, I have the
following but there is no sample folder C:\Program Files\Microsoft SQL
Server\90. I downloaded the adventureworksvbscripts and installed both the
adventureworks and adventureworksDW databases. I will try the link provided.
--
Paul G
Software engineer.
"Ekrem Ã?nsoy" wrote:
> I guess it's about Sql Server Samples. Did you download the latest version
> from the following link:
> http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000
> After installing it, you'll find the AdventureWorks(VB\CS).sln VS solution
> file in the following path:
> C:\Program Files\Microsoft SQL
> Server\90\Samples\Engine\Programmability\CLR\AdventureWorks
> If this is what you are looking for...
> --
> Ekrem Ã?nsoy
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:31D4B610-532F-4916-9C11-325FC5147444@.microsoft.com...
> > HI I have installed the adventure works db scripts and have both the
> > adventureworks and adventureworksdw databases installed. I am missing the
> > adventureworks.sln (adventure works project files). I tried to install
> > adventureworksBI.msi but I got an error that the adventureworks database
> > is
> > already installed. I tried renaming the adventureworks database on the
> > server to something else and tried the install again but I got an error
> > message that it was too old of a version. I am not sure if there is a
> > script
> > I need to run that will instal the project files, Any ideas? thanks.
> > --
> > Paul G
> > Software engineer.
>
Can't Deploy AdventureWorks Database
Hi All,
I created a named instance of SQL SERVER 2005 (Evaluation version) on Windows XP pro, attached the AdventureWorks and AdventureWorks DW databases to the database engine, and tried to deploy the AdventureWorks DW (Enterprise and Standard) database in Analysis Services using SQL SERVER Business Intelligence Development Studio.
For some reason, I encountered the following error (after deployment during processing):
Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; 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.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [2]. ; 08001. 0 0
Please note that I used the configuration manager to enable named pipes and allow remote connections. I also, renamed the target server (to the named server instance instead of the localhost), disabled my Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.
Nothing seems to work. Any help would be greatly appreciated!
Thanks,
Raj
Hi,
We also experienced a similar problem deploying the AdventureWorks DW using the Business Intelligence Development Studio. Our error is as follows:
Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0
This error occurred after we had dropped and uninstalled the sample databases from a previous install. Please note we downloaded the samples from Microsoft and used the AdventureWorks Data Warehouse Database and Analysis Services Project to install the databases.
Brad
|||We are having the exact same error. Did you all find a solution?
|||I'm moving this post to the Tools forum since this isn't a setup or upgrade issue.
G'luck.
|||Hi everyone!I just had the same problem and solved it. What you have to do is:
1) Right-click the project name, and choose properties
2) In the deployment tab change the server name from localhost to your instance name
3) Double-click the data source in solution explorer
4) In General tab click Edit to change the connection string
5) Choose Native OLE DB\Microsoft OLE DB Provider for SQL Server
6) Type in your server name
7) Select the AdventureWorksDW as database name and click OK
Now the deployment should be successfull...|||
Try:
Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.
Can't Deploy AdventureWorks Database
Hi,
We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:
Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0
Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.
Nothing seems to work. Any help would be greatly appreciated!
Thanks,
Brad
I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:
- go to "Impersonation Information" tab
- choose to use "Specific User Name & Password"
- enter an NT user name and password that you know has read rights to the DB
Then try to redeploy and process.
Thanks
Paul Sanders (MSFT)
|||Great...!
Thanks...! It worked for me too.
|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||To: Chu Xu
"and right click on "Adventure Works DW.ds""
Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.
Regards
Can't Deploy AdventureWorks Database
Hi,
We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:
Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0
Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.
Nothing seems to work. Any help would be greatly appreciated!
Thanks,
Brad
I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:
- go to "Impersonation Information" tab
- choose to use "Specific User Name & Password"
- enter an NT user name and password that you know has read rights to the DB
Then try to redeploy and process.
Thanks
Paul Sanders (MSFT)
|||Great...!
Thanks...! It worked for me too.
|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||To: Chu Xu
"and right click on "Adventure Works DW.ds""
Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.
Regards
Can't Deploy AdventureWorks Database
Hi,
We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:
Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0
Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.
Nothing seems to work. Any help would be greatly appreciated!
Thanks,
Brad
I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:
- go to "Impersonation Information" tab
- choose to use "Specific User Name & Password"
- enter an NT user name and password that you know has read rights to the DB
Then try to redeploy and process.
Thanks
Paul Sanders (MSFT)
|||Great...!
Thanks...! It worked for me too.
|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||To: Chu Xu
"and right click on "Adventure Works DW.ds""
Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.
Regards
Can't Deploy AdventureWorks Database
Hi,
We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:
Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0
Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.
Nothing seems to work. Any help would be greatly appreciated!
Thanks,
Brad
I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:
- go to "Impersonation Information" tab
- choose to use "Specific User Name & Password"
- enter an NT user name and password that you know has read rights to the DB
Then try to redeploy and process.
Thanks
Paul Sanders (MSFT)
|||Great...!
Thanks...! It worked for me too.
|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||To: Chu Xu
"and right click on "Adventure Works DW.ds""
Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.
Regards
Can't Deploy AdventureWorks Database
Hi,
We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:
Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0
Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.
Nothing seems to work. Any help would be greatly appreciated!
Thanks,
Brad
I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:
- go to "Impersonation Information" tab
- choose to use "Specific User Name & Password"
- enter an NT user name and password that you know has read rights to the DB
Then try to redeploy and process.
Thanks
Paul Sanders (MSFT)
|||Great...!
Thanks...! It worked for me too.
|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||To: Chu Xu
"and right click on "Adventure Works DW.ds""
Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.
Regards
Can't Deploy AdventureWorks Database
Hi All,
I created a named instance of SQL SERVER 2005 (Evaluation version) on Windows XP pro, attached the AdventureWorks and AdventureWorks DW databases to the database engine, and tried to deploy the AdventureWorks DW (Enterprise and Standard) database in Analysis Services using SQL SERVER Business Intelligence Development Studio.
For some reason, I encountered the following error (after deployment during processing):
Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; 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.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [2]. ; 08001. 0 0
Please note that I used the configuration manager to enable named pipes and allow remote connections. I also, renamed the target server (to the named server instance instead of the localhost), disabled my Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.
Nothing seems to work. Any help would be greatly appreciated!
Thanks,
Raj
Hi,
We also experienced a similar problem deploying the AdventureWorks DW using the Business Intelligence Development Studio. Our error is as follows:
Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0
This error occurred after we had dropped and uninstalled the sample databases from a previous install. Please note we downloaded the samples from Microsoft and used the AdventureWorks Data Warehouse Database and Analysis Services Project to install the databases.
Brad
|||We are having the exact same error. Did you all find a solution?
|||I'm moving this post to the Tools forum since this isn't a setup or upgrade issue.
G'luck.
|||Hi everyone!I just had the same problem and solved it. What you have to do is:
1) Right-click the project name, and choose properties
2) In the deployment tab change the server name from localhost to your instance name
3) Double-click the data source in solution explorer
4) In General tab click Edit to change the connection string
5) Choose Native OLE DB\Microsoft OLE DB Provider for SQL Server
6) Type in your server name
7) Select the AdventureWorksDW as database name and click OK
Now the deployment should be successfull...|||
Try:
Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.
Sunday, March 11, 2012
Can't Deploy AdventureWorks Database
Hi All,
I created a named instance of SQL SERVER 2005 (Evaluation version) on Windows XP pro, attached the AdventureWorks and AdventureWorks DW databases to the database engine, and tried to deploy the AdventureWorks DW (Enterprise and Standard) database in Analysis Services using SQL SERVER Business Intelligence Development Studio.
For some reason, I encountered the following error (after deployment during processing):
Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; 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.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [2]. ; 08001. 0 0
Please note that I used the configuration manager to enable named pipes and allow remote connections. I also, renamed the target server (to the named server instance instead of the localhost), disabled my Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.
Nothing seems to work. Any help would be greatly appreciated!
Thanks,
Raj
Hi,
We also experienced a similar problem deploying the AdventureWorks DW using the Business Intelligence Development Studio. Our error is as follows:
Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0
This error occurred after we had dropped and uninstalled the sample databases from a previous install. Please note we downloaded the samples from Microsoft and used the AdventureWorks Data Warehouse Database and Analysis Services Project to install the databases.
Brad
|||We are having the exact same error. Did you all find a solution?
|||I'm moving this post to the Tools forum since this isn't a setup or upgrade issue.
G'luck.
|||Hi everyone!I just had the same problem and solved it. What you have to do is:
1) Right-click the project name, and choose properties
2) In the deployment tab change the server name from localhost to your instance name
3) Double-click the data source in solution explorer
4) In General tab click Edit to change the connection string
5) Choose Native OLE DB\Microsoft OLE DB Provider for SQL Server
6) Type in your server name
7) Select the AdventureWorksDW as database name and click OK
Now the deployment should be successfull...|||
Try:
Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.
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
|||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.|||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
|||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
|||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.|||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
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
|||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.|||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
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
|||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.|||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
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
|||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.|||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
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
|||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.|||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
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
|||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.|||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
|||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.
Subscribe to:
Posts (Atom)