Another SQL script question.

Hey all,

How do i make sure that the local machine aspnet user account has privilages after installing my sql script on a local machine. ( this script gets run during my vb.net setup project. )

i was thinking about adding the user to the sql script its self. but i am unsure how to do this.

if anyone could help i would be greatly appreciative.

TIA

-Chris-Check out this link.

The link is for MSDE but applies to Sql Server too. It shows the syntax for adding new users to a database server and granting them access to specific databases.|||Thanks for you reply.

the syntax for adding a user assumes you know the full nt user account info. correct?

domain\user account.

what i would like to do is add the local machine\aspnet account. without knowing what the name of the local machine is.

if you have suggestion, please let me know.

TIA

Chris.|||I've gotten around that problem by using Sql Server authentication instead of a trusted connection.

-- Create Sql authentication login for 'SomeName'
EXEC sp_addlogin @.loginame='SomeName',@.passwd='SomePassword',@.defdb=N'SomeDefaultDb'
-- and making sure you are executing from 'SomeDatabase' grant access to 'SomeName' to the database 'SomeDatabase'
EXEC sp_grantdbaccess 'SomeName'

There is probably some server side property or method you can call that will tell you who the ASPNET user is running as (e.g., domain\ASPNET) which would allow you to use the other syntax to create a trusted connection.

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 !

Anonimous subscription: could not make it work

Hi,

here is how the computers are connected:

2 iNet Computers with the 1433 port redirected to other computers on the local network wich have SQL Server; the synchronization is made between these inet computers; when establishing connection to distributor I get this message: the SQL Server didn't exist or access is not allowed;
the push subscription works but i need an anonimous subscription.

what is the problem and how i can fix it?
is this a security problem?

any questions are welcomeread books on line...very good for this

Also, a publication needs to have the correct people given access to it.

Cheers

SG

Analysis Services Question

Hi all.

I'm a new user to Analysis Services and am really stuck.

I have Cube on a local copy of SQL Server - Analysis Services (Personal Edition). I have the same Cube in a production server (Enterprise Edition).
When the cube gets rebuilt it takes about 45 minutes on my local machine and about 23 hours on the production machine. They are running with the same amount of rows in the data (13 million).

One thing I noticed is that the data is written to 9 segments of the partition on my local. And when running the process in production, it reads and writes the records alot slower, and I do not
notice any segments being written.

Is there any special setting with storage when building a Cube. I used mostly default setting on the local. I'm not sure about in Production and not sure how to check.

If anyone has any ideas on where to look or any ideas as to what could be causing this - it would be greatly appreciated.

Thanks.May check http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx for info.

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 Deployment/Management Question

I have a local server for development that is on my local domain that I can work on very easily. However, my production server is offsight and on a different domain. Since Management Studio will only allow Windows Authentication when connecting to an Analysis Services instance, how can I manage the remote cube without having to remote desktop into the production server?

TIA

Right, you need to either TS to the machine, or establish a VPN connection to the domain. One possible, solution would be to use SQL Managment Studio against your local AS database, and instead of committing the changes, script out the XMLA. Then, if you had an http pump setup on a middle-tier, you could send the XMLA to via http using an admin user basic authentication that you create and you'd have a way to effectively do the administrative actions that you want. This isn't straightforward, but would get the job done.

Hope that helps.