another simple question, please help, thx a lot!

I have some issues for remotely connection a sqlexpress server 2005 with a c# desktop app,

in my local network, after I set a port forwarding service for the computer which runs sqlexpress server, I want my c# app connect to the sqlexpress server in another machine under same local network, the connection string is:

"server= 62.31.81.210.\SQLEXPRESS,1921; Database='EvoHealthSQLex'; Integrated Security=True"

however, that one only work in the sqlexpress server machine, if I try to use it in another machine, i got error 'Login failed for user 'BRISTOL-1\Guest', BRISTOL-1 is the full computer name of sqlexpress server machine, I found out the solution is to create a login for 'BRISTOL-1\Guest' (in sever management studio express):

CREATE LOGIN [BRISTOL-1\Guest] FROM WINDOWS; GO

then it fixed the problem I mentioned above, However, what I want to ask is when I change the server authentication from 'windows authentication mode' to 'Sql server and windows authtication mode', then i try to create a user like this:

CREATE LOGIN Ross WITH PASSWORD = 'changeme'; USE EvoHealthSQLex; CREATE USER Ross; GO 

Then I change my connection string to:

"server= 62.31.81.210.\SQLEXPRESS,1921; user id='Ross'; password='changeme'; Database='EvoHealthSQLex';

then I got the following error even when I user 'sa' user:

An unhandled exception of type 'System.Configuration.ConfigurationException' occurred in system.dll

I wonder why this happening ? it should be a stupid connectionstring problem just I don't know ..

I wonder can I use 'windows authentication' for remote access (outside local network)? if so, how do i specified the username, all BRISTOL-1\Guest ?

thanks a lot for your reading!

Can you post the extire exception stack trace?|||

sorry, it was a syntax program, I was being silly again...

it should be:

"server= 62.31.81.210.\SQLEXPRESS,1921; user id='Ross'; password='changeme'; Database='EvoHealthSQLex' "

I put a extra ';' in the end of the statement :

"server= 62.31.81.210.\SQLEXPRESS,1921; user id='Ross'; password='changeme'; Database='EvoHealthSQLex' ; "

now above error message disappear!

thanks very much for your help, learn a lot for this forum, as a newbie :)

|||

Hi, got a last question of this remote connection problem:

I send my program to my friend and ask him run it (as all my computer is within the same local network, although I use the router Ip address 62.31.81.210 instead of local ip address 168.192.0.3) and he got a error say' SQL server is not exist or access denied', I wonder whatelse can cause that happen ? anything to do with the port forwarding service? he does can browse my test website hosting in the same machine using the same ip address http://62.31.81.210(I also do a port forwarding service with port 80 as well), I wonder why he failed to connect to sqlexpress server...

Many thanks!

|||

You can find lots of troubleshooting info through

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

In your case, the errormsg indicates that the client do not have connecitivity to the server. "168.192.0.3" mean host local address, which normally mean the host does not haveconnecitvity to the network. I am surprised that with 168.192.0.3, you can browse the server.

One you made sure you have network connectivity, you can try to "telnet 62.31,81,210 port" to see if TCP connectivity is ok between your client host and remote server. "use ctrl +]" and "quit" to exit the telnet console.

Once you have telnet test passes, you may try your sql connection.

|||

hi, thanks for your reply again, I just ask my another friend to try it and it works! I didn't use the local Ip address '168.192.0.3', I use the '62.31,81,219 1921', and I connect it with tcp/ip with no problem, so probably is my first friend's computer problem.

so far so good, thanks so much for your help, really appreciated !

Another Connection Problem

Hi all,
I am starting to work with MSDE. I have no problem connecting to the Northwind db, but every time I create a new database, I can't open it.
I have used ...
"Data Source=MyTestDb;Initial Catalog=mytable;Integrated Security=SSPI;"
the error I receive is:
Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'MyTestDb'. Login fails. Login failed for user 'HOODWKOTC124874\ASPNET'.

I have also used...
what I thought was the default user id =sa; password =;

I can make a winform and drop sql objcets on the page and connect to the db that I created, just not through asp.net

FYI- I do not have Enterprise manager.

Any help would be appreciated.

ThanksOpen Enterprise manager and create a login for ASPNET and grant it perms on the MyTable db.

Hope that helps
Kashif|||I don't have enterprise manager. I am using the MSDE.|||You can use OSQL, included with MSDE. You need to have the folder that OSQL is in on your path, or be in that folder.

Using the command prompt, type the following, substituting your COMPUTERNAME and databasename:

osql -S servername\instancename -E -q
 --Line numbers will appear
EXEC sp_grantlogin 'COMPUTERNAME\ASPNET'
go
use <databasename>
go
EXEC sp_grantdbaccess 'COMPUTERNAME\ASPNET'
go
EXEC sp_addrolemember 'db_owner', 'COMPUTERNAME\ASPNET'
go

Anonymous connection to a remote server

I have a SQL server running on a Win2k Domain Controller set for Windows Aut
hentication only.
I have a Windows 2003 Web Edition server that is a member of the domain.
When permissions are correct I can open and update databases on the server f
rom the Web Edition server.
I want to allow anyone that hits a web site on the 2003 server to be able to
update a specific database on the SQL server. The
users on that site are running under the local IIS anonymous user id.
I tried the obvious and simple connection
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Ini
tial Catalog=WebRedirectLog;Data Source=ZEUS;
Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation
ID=ROY;Use Encryption for Data=False;
Tag with column collation when possible=False");
(which I expected to fail) and it did telling me
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Se
rver connection.
(I did NOT supply a userid in the call to ADODB.Connection.Open
What is the correct way to do one of the following.
1) - Allow all users (authenticated or not) to update a database?
2) - Set up the SQL server so that it can treat the 2003 local account (not
a domain account) as authenticated.
I do NOT want to allowed mixed mode authentication on this server.
Please bear in mind, I am still a novice at administering SQL, so please mak
e your response a little detailed.
Thanks
---
Roy Chastain
KMSystems, Inc.Hi Roy,
Welcome to MSDN newsgroup.
Regarding on the problem you mentioned, I think the it'll be a bit
difficult to meet all your requirement. Here are some of my understandings:
First, ASP will always impersonate the anonymous account( IIS's default
IUSR_machine account) if we enable anonymous access in our IIS virtual dir.
Then, when our asp page try accessing any protected resource, the
IUSR_machine account will be the authenticated and executing account of our
asp page's thread. Then, return back to the quesitons you mentioned:
==============
What is the correct way to do one of the following.
1) - Allow all users (authenticated or not) to update a database?
2) - Set up the SQL server so that it can treat the 2003 local account (not
a domain account) as authenticated
==============
1) I think the most standard means for allow all users to access db is to
use SQLServer Autehntcaiton(provide the username account in
connectionstring. This will require the SQLServer db to allow SQL
authentication. In fact, this is limited by the ASP , in asp.net we can
impersonate a certain fixed account so as to use t hat account to access
the database through integrated windows authentication.
2) If the webserver and SqlServer's database server is the same box, we
can simply grant the IIS's IUSR_MACHINE account the permisson to access
sqlserver db. However, as you said the DB server is a remote server to the
webserver, the IUSR_machine(local account ) on webserver is not valid on DB
server. For such scenario, there are two options:
a. use a Domain Account as your IIS virtual dir's anonymous account.
(Seems you didn't want to use DomainAcount )
b. create a duplicate local account on the SQLServer 's machine which has
the same username and password with the IIS virtual dir's anonymous account
(on the webserver box). However, the IIS's default anonymous account(
IUSR_MACHINE) 'S password is controled by machine rather than ourself. So
we need to either explicitly set IUSR_MACHINE's password or create a
custom local account and replace the IUSR_machine as the virtual dir's
anonymous account.
Anyway, since there hasn't any means which will satisfy all the
requirement, we may need to make our decision according to the actual
situation. Please have a look of all the above things and feel free to let
us know if you have any ideas.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Here is what I did and it is working and I think secure for what I want.
I created a new domain account and gave it insert and select access to the d
atabase.
I set anonymous access for the web site to that account.
I created a Application Pool on the web server and have it running under tha
t account.
I set the web site to use the newly created Application Pool.
From my point of view that gives all anonymous users of this one web site an
onymous access to the SQL database for the purposes of
inserting and selecting. I would have been easier is SQL supported some sor
t of anonymous access setting that said don't validate
this user, just let them do this, but...
Please let me know if you see any flaws in my reasoning.
Thanks
On Thu, 14 Apr 2005 05:18:35 GMT, v-schang@.online.microsoft.com (Steven Chen
g[MSFT]) wrote:

>Hi Roy,
>Welcome to MSDN newsgroup.
>Regarding on the problem you mentioned, I think the it'll be a bit
>difficult to meet all your requirement. Here are some of my understandings:
>First, ASP will always impersonate the anonymous account( IIS's default
>IUSR_machine account) if we enable anonymous access in our IIS virtual dir.
>Then, when our asp page try accessing any protected resource, the
>IUSR_machine account will be the authenticated and executing account of our
>asp page's thread. Then, return back to the quesitons you mentioned:
>==============
>What is the correct way to do one of the following.
>1) - Allow all users (authenticated or not) to update a database?
>2) - Set up the SQL server so that it can treat the 2003 local account (not
>a domain account) as authenticated
>==============
>1) I think the most standard means for allow all users to access db is to
>use SQLServer Autehntcaiton(provide the username account in
>connectionstring. This will require the SQLServer db to allow SQL
>authentication. In fact, this is limited by the ASP , in asp.net we can
>impersonate a certain fixed account so as to use t hat account to access
>the database through integrated windows authentication.
>2) If the webserver and SqlServer's database server is the same box, we
>can simply grant the IIS's IUSR_MACHINE account the permisson to access
>sqlserver db. However, as you said the DB server is a remote server to the
>webserver, the IUSR_machine(local account ) on webserver is not valid on DB
>server. For such scenario, there are two options:
>a. use a Domain Account as your IIS virtual dir's anonymous account.
>(Seems you didn't want to use DomainAcount )
>b. create a duplicate local account on the SQLServer 's machine which has
>the same username and password with the IIS virtual dir's anonymous account
>(on the webserver box). However, the IIS's default anonymous account(
>IUSR_MACHINE) 'S password is controled by machine rather than ourself. So
>we need to either explicitly set IUSR_MACHINE's password or create a
>custom local account and replace the IUSR_machine as the virtual dir's
>anonymous account.
>Anyway, since there hasn't any means which will satisfy all the
>requirement, we may need to make our decision according to the actual
>situation. Please have a look of all the above things and feel free to let
>us know if you have any ideas.
>Thanks,
>Steven Cheng
>Microsoft Online Support
>Get Secure! www.microsoft.com/security
>(This posting is provided "AS IS", with no warranties, and confers no
>rights.)
>
>
---
Roy Chastain
KMSystems, Inc.|||Glad to hear from you Roy,
I think it's OK since ASP will impersonate the authenticated user by
default( if allow anonymous then impersonate the anonymous user). And
using Integrated windows authentication at back end db is also what we
recommend.
BTW, is there any future action plan that you'll migrate your web
application from classic ASP to ASP.NET. The asp.net web app framework will
have more strong support for stable and high performance web application.
Also, as for security, the asp.net can let the asp.net running under the
process idenity (the application pool identity in IIS6) together with allow
anonymous in IIS. Thus, we can still keep the IIS's anonymous account as a
very restricted account.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Anonymous connection to a remote server

I have a SQL server running on a Win2k Domain Controller set for Windows Authentication only.
I have a Windows 2003 Web Edition server that is a member of the domain.
When permissions are correct I can open and update databases on the server from the Web Edition server.
I want to allow anyone that hits a web site on the 2003 server to be able to update a specific database on the SQL server. The
users on that site are running under the local IIS anonymous user id.
I tried the obvious and simple connection
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=WebRedirectLog;Data Source=ZEUS;
Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ROY;Use Encryption for Data=False;
Tag with column collation when possible=False");
(which I expected to fail) and it did telling me
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
(I did NOT supply a userid in the call to ADODB.Connection.Open
What is the correct way to do one of the following.
1) - Allow all users (authenticated or not) to update a database?
2) - Set up the SQL server so that it can treat the 2003 local account (not a domain account) as authenticated.
I do NOT want to allowed mixed mode authentication on this server.
Please bear in mind, I am still a novice at administering SQL, so please make your response a little detailed.
Thanks
Roy Chastain
KMSystems, Inc.
Hi Roy,
Welcome to MSDN newsgroup.
Regarding on the problem you mentioned, I think the it'll be a bit
difficult to meet all your requirement. Here are some of my understandings:
First, ASP will always impersonate the anonymous account( IIS's default
IUSR_machine account) if we enable anonymous access in our IIS virtual dir.
Then, when our asp page try accessing any protected resource, the
IUSR_machine account will be the authenticated and executing account of our
asp page's thread. Then, return back to the quesitons you mentioned:
==============
What is the correct way to do one of the following.
1) - Allow all users (authenticated or not) to update a database?
2) - Set up the SQL server so that it can treat the 2003 local account (not
a domain account) as authenticated
==============
1) I think the most standard means for allow all users to access db is to
use SQLServer Autehntcaiton(provide the username account in
connectionstring. This will require the SQLServer db to allow SQL
authentication. In fact, this is limited by the ASP , in asp.net we can
impersonate a certain fixed account so as to use t hat account to access
the database through integrated windows authentication.
2) If the webserver and SqlServer's database server is the same box, we
can simply grant the IIS's IUSR_MACHINE account the permisson to access
sqlserver db. However, as you said the DB server is a remote server to the
webserver, the IUSR_machine(local account ) on webserver is not valid on DB
server. For such scenario, there are two options:
a. use a Domain Account as your IIS virtual dir's anonymous account.
(Seems you didn't want to use DomainAcount )
b. create a duplicate local account on the SQLServer 's machine which has
the same username and password with the IIS virtual dir's anonymous account
(on the webserver box). However, the IIS's default anonymous account(
IUSR_MACHINE) 'S password is controled by machine rather than ourself. So
we need to either explicitly set IUSR_MACHINE's password or create a
custom local account and replace the IUSR_machine as the virtual dir's
anonymous account.
Anyway, since there hasn't any means which will satisfy all the
requirement, we may need to make our decision according to the actual
situation. Please have a look of all the above things and feel free to let
us know if you have any ideas.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Here is what I did and it is working and I think secure for what I want.
I created a new domain account and gave it insert and select access to the database.
I set anonymous access for the web site to that account.
I created a Application Pool on the web server and have it running under that account.
I set the web site to use the newly created Application Pool.
From my point of view that gives all anonymous users of this one web site anonymous access to the SQL database for the purposes of
inserting and selecting. I would have been easier is SQL supported some sort of anonymous access setting that said don't validate
this user, just let them do this, but...
Please let me know if you see any flaws in my reasoning.
Thanks
On Thu, 14 Apr 2005 05:18:35 GMT, v-schang@.online.microsoft.com (Steven Cheng[MSFT]) wrote:

>Hi Roy,
>Welcome to MSDN newsgroup.
>Regarding on the problem you mentioned, I think the it'll be a bit
>difficult to meet all your requirement. Here are some of my understandings:
>First, ASP will always impersonate the anonymous account( IIS's default
>IUSR_machine account) if we enable anonymous access in our IIS virtual dir.
>Then, when our asp page try accessing any protected resource, the
>IUSR_machine account will be the authenticated and executing account of our
>asp page's thread. Then, return back to the quesitons you mentioned:
>==============
>What is the correct way to do one of the following.
>1) - Allow all users (authenticated or not) to update a database?
>2) - Set up the SQL server so that it can treat the 2003 local account (not
>a domain account) as authenticated
>==============
>1) I think the most standard means for allow all users to access db is to
>use SQLServer Autehntcaiton(provide the username account in
>connectionstring. This will require the SQLServer db to allow SQL
>authentication. In fact, this is limited by the ASP , in asp.net we can
>impersonate a certain fixed account so as to use t hat account to access
>the database through integrated windows authentication.
>2) If the webserver and SqlServer's database server is the same box, we
>can simply grant the IIS's IUSR_MACHINE account the permisson to access
>sqlserver db. However, as you said the DB server is a remote server to the
>webserver, the IUSR_machine(local account ) on webserver is not valid on DB
>server. For such scenario, there are two options:
>a. use a Domain Account as your IIS virtual dir's anonymous account.
>(Seems you didn't want to use DomainAcount )
>b. create a duplicate local account on the SQLServer 's machine which has
>the same username and password with the IIS virtual dir's anonymous account
>(on the webserver box). However, the IIS's default anonymous account(
>IUSR_MACHINE) 'S password is controled by machine rather than ourself. So
>we need to either explicitly set IUSR_MACHINE's password or create a
>custom local account and replace the IUSR_machine as the virtual dir's
>anonymous account.
>Anyway, since there hasn't any means which will satisfy all the
>requirement, we may need to make our decision according to the actual
>situation. Please have a look of all the above things and feel free to let
>us know if you have any ideas.
>Thanks,
>Steven Cheng
>Microsoft Online Support
>Get Secure! www.microsoft.com/security
>(This posting is provided "AS IS", with no warranties, and confers no
>rights.)
>
>
Roy Chastain
KMSystems, Inc.
|||Glad to hear from you Roy,
I think it's OK since ASP will impersonate the authenticated user by
default( if allow anonymous then impersonate the anonymous user). And
using Integrated windows authentication at back end db is also what we
recommend.
BTW, is there any future action plan that you'll migrate your web
application from classic ASP to ASP.NET. The asp.net web app framework will
have more strong support for stable and high performance web application.
Also, as for security, the asp.net can let the asp.net running under the
process idenity (the application pool identity in IIS6) together with allow
anonymous in IIS. Thus, we can still keep the IIS's anonymous account as a
very restricted account.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Analysis Services Step by Step - connection problem

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

I downloaded the trial version from MS and installed in om my laptop from where im running my tutorial - what could be wrong? (Im a newbie to SQL so I have no clue)

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

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

|||

Edward Melomed wrote:

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

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

I have the following services running:

SQL Server, SQL Server Agent, SQL Server Browser, SQL Server FullText Search, SQL Server Integration Services and SQL Server VSS Writer - I can't see any Analysis related services on my services list?

|||

It is working now - thanks alot for your help.

I reinstalled my solution and for some reason I didnt have the Analasis services correctly installed.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my server name)' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

I am totally new in this area..

Please solve it.. Thanks.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my server name)' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my server name)' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my server name)' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my server name)' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services Project - A connection cannot be made. Ensure the server is running.

Hi there

I have created an Analysis services project on a laptop running developer edition SQL 2005. The database is hosted on the local machine. When I attempt to debug or deploy the project I get an error;

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

It seems bizarre as I can view tables, create dimensions, cubes etc also I have database as a connection in the server explorer.

I have checked that the services are running, I've restarted them also just in case.

Any ideas would be much appreciated.

Regards,

Derek

Hello derek

I got the same problem yesterday and the solution to this problem is to right click on the project in solution explorer.say MovieSample is a project right click on it and then go to Properties.In properties on th left hand side select deployment and change the server name.By default the server name is localHost so replace it with your machine name and then instance of sql server 2005 like aliraza/sqlserver2005.

try this and i am pretty sure that this will work fine for you.

ali

|||This post looks old but for those of you just looking now you might also try making sure you have Analysis Services started.|||

Hi,

What is Analysis Serves? How can I start it? And I entered my server name but still it is saying me same error. Error 1 The project could not be deployed to the 'xxxx(my server name)' server because of the following connectivity problems : A connection cannot be made. Ensure that the server 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.

I am totally new in this area..

Please solve it.. Thanks.

|||

Hi,

1.Make sure you have entered the server name correctly and

2.if you are connecting to a remote server its fine or if you are connecting to the SSAS through http then you may have to configure that(hit google 4 more help)

I think in your case the SSAS service is not started,mostly SSAS service when installed is tagged as 'manual'

so please 'start' the SSAS service and try deploying !!

|||I'm having the similar problem as stated above. how bout i've got both SSAS running already but still doesnt seems working. what should I do?|||

In solutions Explorer

Click Name of the project and right click and go to properties.Expand Configuration Properties and click deployment.Change the server to the correct name of the server with any instance.

Expand Data Sources and double click your data source.Go to imprsonate Information and check use a specific user name and password radio button and enter domain user having sysadmin rights of your database and password.

Analysis Services connection using AMO

Hi,

I have AS2005 running on a development machine, and i am trying to connect to it via my application running on another machine.

The code is using the Analysis Mangement Object (AMO) API.

Currently, my application code only tries to connect and disconnect from the server.

Server svr = new Server();

svr.Connect(connectionString); < Exception thrown here

svr.Disconnect();

The connectionString simply contains the remote server's name. I have also tried different connection strings but it has not helped.

I have also enabled remote connections on AS, and opened the default port number on the server's firewall.

Every time it tries to connect the exception thrown is:

"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."

Can anybody help me with this problem?

I'm not sure if this will help, but I was getting a similar error with

the BI Development Studio. In that case it was a security

issue. Basically, becasue the machine was on a different domain,

I had to create a user on that machine with the same username /

password as the one that I log into my machine with. Have you

tried connecting in any other way?|||

Is the "other machine" an AS2K5 instance?

_-_-_ Dave

Analysis Services Connection problem.

I am trying to test a connection in Reporting Services to an Analysis Services 2000 database. I get a Test Connection Succeeded from one machine and I can't even select the databases in the connection properties on another machine. What can I look at that might be preventing one machine from seeing the Analysis Services Server?

Thanks.

Security. If you hardcode the Windows credentials in the connection string does it work? This whitepaper may help.

Analysis services connection problem

Hi,

I created a shared datasoure to point to a remote AS server, when I clicked "Test Connection" it succeeds.

I used the query builder to create an MDX query by dragging items from the cube, the results appear in the right hand paine when I do this which tells me that I am connecting to the cube successfully. I then finish the wizard which creates my report.

The problem comes when I click "Preview", I get the following error message:

An error occurred during local report processing.
An error occurred during report processing.
Cannot create a connection to data source 'SalesMartCube'
A connection cannot be made. Ensure that the server is running.
No connection could be made because the target machine actively refused it.

Why would I be able to see the query results in query builder but not when I preview the report?

Thanks,

Lachlan

Hi,

Did you have any joy with this as i am getting exactly the same problem?

Any advice would help.

Thanks

Analysis Services Connection problem

I can't connect to Analysis Services accroding execl
pivottable. The error message is "Unable to open
connection. Cannot connect to cube
file. '10.97.69.212',file may be in use." The TCP/IP is
well but the client is not a domain user.What is the
prolem? How to resolve it?Are you specifying an IP address instead of a computer name?
243093 FIX: Using an IP Address for OLAP Data Source Connection Property
Causes
http://support.microsoft.com/?id=243093
Are you going across domains? If so, you'll need to follow these
instructions:
280431 How to Enable Commerce Server 2000 OLAP Reports Over HTTPS with SQL
http://support.microsoft.com/?id=280431
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Analysis services connection from Data Source

Hello everybody.

I want to perform a Analysis Services Processing Task using a connection manager created from a Analysis Services data source. I create the data source using the Oledb provider for Analysis Services 9.0, and it works fine. Then I create a connection manager using the "New connection from data source" option, and it seems to create it ok.

The problem is that I can't then asign this connection to the Analysis Services processing task. I get the error:

"Connection Manager MyConectionManagerFromDataSource is not a Analysis Services Connection Manager"

However, if I create directly a connection manager using "New Analysis Services Connection" it works fine.

Is it at all possible to create a Analysis services connection from a Data Source to perform a Analysis Services Processing Task?

Thanks in advance,

Check the two Connection Manager that you have created. There must be some difference between them.

-Jamie

|||

Thanks Jamie.

I've been checking the connection strings, and there is a slight difference:

Analysis services connection manager:

Data Source=myserver;Initial Catalog=mycatalog;Provider=MSOLAP.3;Integrated Security=SSPI;Impersonation Level=Impersonate;

Connection manager from data source:
Provider=MSOLAP.3;Data Source=myserver;Integrated Security=SSPI;Initial Catalog=mycatalog;Impersonation Level=3

I've tried to change the Impersonation Level to Impersonate in the Data Source, but only integer values are alowed.

Also, in the connection manager type, I have MSOLAP90 for the AS connection manager, and OLEDB for the CM from Data source. I think this must be the issue, but I'm not able to change the connection manager type

Thanks again,

Analysis services connection

Hi!!
1. I am working with Analysis services 2005 and I would want to know
if, Is it recommendable to separate the DB server from of server AS?,
Since when I consult the cubes diminishes the performance the server of
database.
2. How I can to create news administrators OLAP in SQL 2005?
Is there one book what you can recommend on how connecting to me of
remote form?
Thanks,
Cecilia
Chile
1. Yes, you can run SQL and AS on separate machines, just be aware that
each machine would require its own SQL license.
2. To create add a user to the administration group at the server level
for AS you need to open up SQL Server Management Studio, connect to your
server, right click and select "properties" and then go to the security
settings and add the user to the list there.
Regards
Darren Gosbell [MVP]
Blog: http://geekswithblogs.net/darrengosbell
*** Sent via Developersdex http://www.codecomments.com ***
|||The connection of server work, thanks Darren.
Now I have other doubts:
1. if I have SQL server and AS on separate machines and I execute a MDX
query for a rolap cube, consume this query too many resources on the BD
server?
2. it really improves the performance of my server, if i separate it in
the 2 mentioned machines?
3. What percent of the load of a query takes the BD machine, (aprox)?
Thanks,
Cecilia

Analysis services connection

Hi!!
1. I am working with Analysis services 2005 and I would want to know
if, Is it recommendable to separate the DB server from of server AS?,
Since when I consult the cubes diminishes the performance the server of
database.
2. How I can to create news administrators OLAP in SQL 2005?
Is there one book what you can recommend on how connecting to me of
remote form?
Thanks,
Cecilia
Chile1. Yes, you can run SQL and AS on separate machines, just be aware that
each machine would require its own SQL license.
2. To create add a user to the administration group at the server level
for AS you need to open up SQL Server Management Studio, connect to your
server, right click and select "properties" and then go to the security
settings and add the user to the list there.
Regards
Darren Gosbell [MVP]
Blog: http://geekswithblogs.net/darrengosbell
*** Sent via Developersdex http://www.codecomments.com ***|||The connection of server work, thanks Darren.
Now I have other doubts:
1. if I have SQL server and AS on separate machines and I execute a MDX
query for a rolap cube, consume this query too many resources on the BD
server?
2. it really improves the performance of my server, if i separate it in
the 2 mentioned machines?
3. What percent of the load of a query takes the BD machine, (aprox)?
Thanks,
Cecilia|||In article <1163085164.731268.160000@.e3g2000cwe.googlegroups.com>,
Hoody.cu@.gmail.com says...
> The connection of server work, thanks Darren.
> Now I have other doubts:
> 1. if I have SQL server and AS on separate machines and I execute a MDX
> query for a rolap cube, consume this query too many resources on the BD
> server?
>
Sorry, but ROLAP cubes are the one exception. In the case of ROLAP, the
AS server is really just a thin semantic layer that translates MDX into
SQL and runs some pretty large queries against the DB server

> 2. it really improves the performance of my server, if i separate it in
> the 2 mentioned machines?
>
This really only makes a difference when AS is using MOLAP storage as
then it has its own copy of the data and may not need to query the DB
server at all after it has gone through it's processing stage

> 3. What percent of the load of a query takes the BD machine, (aprox)?
>
For ROLAP probably 99%
For MOLAP 0%
(after the data has been read once during the processing stage)
I assume that you are using ROLAP because you need "real-time" data. I
don't know what your exact requirements are, or if you have looked into
any of this before, but AS has a number of ways of implementing "near
real-time" systems. So that if it works with your data and your users
can accept some degree of "lag" in the update of their reports you
should be able to get an increase in the performance of your MDX queries
and reduce the load on your DB server.
If you are interested in this there are a couple of different features
you could read up on.
1) proactive caching - can automatically keep your MOLAP storage up to
date, based either on notifications or polling the source system.
2) You can use incremental processing and schedule a job to run on a
periodic basis to refresh the MOLAP store.
These options do not fit all circumstances and sometimes you may need to
use ROLAP storage, but if you can avoid ROLAP you will probably have a
much better experience.
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

Analysis Services 2005: "OLE DB error: OLE DB or ODBC error : Access denied" using an

Hi,

The source DB is in Oracle 9.i . I use the native pilot from Oracle. The connection test is OK. I can also explore the data in the Data Source View whithout any problem. But when I try to process the dimension, I get the error message "OLE DB error: OLE DB or ODBC error : Access denied.." . I tried with the Native pilot from MS for Oracle but got the same result.

Could anyone help me ?

Rg.

In your datasource try to use Microsoft OLEDB Provider for Oracle or .NET Oracle Client Data Provider.

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

|||

Hi,

Edward, thanks for the fast answer.

with the MS provider and had the error :|||

During deployment of dimensions ( and cubes as well ) Analysis Server tries to process these dimensions. And for that it need to read data from Oracle.

The problem looks like related to the configuration of Oracle client. Also a good idea to check access permissions to Oracle database. See also if changing service account for the Analysis Server solves your problem.

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

|||

Hi Edwards,

I changed the service account in the "SQL server configuration manager", for Analysis services and now it works fine :D

Thanks for your help,

Sbastien