SQL Configure: studio

Showing posts with label studio. Show all posts

Sunday, 25 March 2012

connect to server name 2005!

First time I am using sql server 2005.
What is the default server name' I can not see anything in managment
studio.
whenever i tried to connect OR create database through SQL sever
Management studio, it asked me:
server type: (here i select Database Engine)
server Name : ( '')
Authentication : which one I have to use? (Windows Authentiction is by
default, another is SQL server Authentication,)...
I don't know what to do with server name . Please advise.Hi,
please do not mulitpost, answered in public.sqlserver
HTH, jens Suessmeyer.
--
http://www.sqlserver2005.de
--sql sql

Connect to Remote SQL SERVER Express 2005 server

I am trying to connect to a remote SQL Express server (using query analyzer)
and I am not able to. If I run SQL Server Managemant Studio I can connect
(using Windows Authentication). I have tried using the IP address of the
server and just the server name but no luck. There is only one instance
running on the server (default). This server is on a different subnet. The
error I receive is: Server: Msg 14, Level 16, State1
[microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
Any ideas?
TimAre you sure the SQL Express instance is the default? It normally installs
as a named instance SQLEXPRESS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>I am trying to connect to a remote SQL Express server (using query
>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>can connect (using Windows Authentication). I have tried using the IP
>address of the server and just the server name but no luck. There is only
>one instance running on the server (default). This server is on a
>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
> Any ideas?
> Tim
>|||You are right. When I try connecting using servername/sqlexpress I get the
following error:
[DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
Denied.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
> Are you sure the SQL Express instance is the default? It normally
> installs as a named instance SQLEXPRESS.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>|||How about servername\sqlexpress ? Is the SQLBrowser enabled and running on
the SQL Express server?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
> You are right. When I try connecting using servername/sqlexpress I get
> the following error:
> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
> Denied.
> Thanks,
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>|||Got the same error. I found a registry entry that fixed the problem.
HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo.
Added REG_SZ key <servername> with data set to:
<servername>,DBMSSOCN,<servername>,1433
Don't know what this does, but I am able to connect now.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uP3wAxRzGHA.2036@.TK2MSFTNGP05.phx.gbl...
> How about servername\sqlexpress ? Is the SQLBrowser enabled and running
> on the SQL Express server?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
>> You are right. When I try connecting using servername/sqlexpress I get
>> the following error:
>> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
>> Denied.
>> Thanks,
>>
>> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
>> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is
>>only one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>>
>

Connect to Remote SQL SERVER Express 2005 server

Connect to remote RS in SSMS

Got following error when try to connect to remote reporting service in SSMS:

TITLE: Microsoft SQL Server Management Studio

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that? Thanks.

Odd - You're logged in on as the same user on both computers? Are both computers in the same domain?

Can you access the report server in a web browser from the remote computer?

If you can, try this:

in the SSMS connection dialog. Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

Does that work?

-Lukasz

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

|||Yes, I can access the report server in a web browser from same remote computer where I tried to connect RS in SSMS. Replacing server name with RS url doesn't work either, got same 401 error.|||Is the user in the Administrators group on the box?|||Yes, it's local admin on both server and client machine.|||Very strange.. Since it is a 401 error, maybe you could look in the %windir%\system32\LogFiles\W3SVC1 for the latest log file to see what request is being denied.|||

Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine. Type in your windows credentials and see if you get the same error.

-Lukasz

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

|||

I found followings in the log file, any hint? By the way, got same error when try to connect with basic authentication. Thanks.

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

|||

Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory.

By default these are:

Report Manager: http://localhost/reports

Report Server: http://localhost/reportserver

-Lukasz

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

|||Worked with report server url, thanks for the help.|||Glad to see it worked for you.
Can you provide the IIS logs for when you try to connect using just server\instance in the SSMS connection dialog. I'm curious to know why you can't connect to RS with management studio.
Thanks,
-Lukasz

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

Did you ever find out why you couldn't just us the servername in SSMS? I am having this same problem.

Thanks,

Bryan

|||No, fine with me to use url.

Connect to remote RS in SSMS

Got following error when try to connect to remote reporting service in SSMS:

TITLE: Microsoft SQL Server Management Studio

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that? Thanks.

Odd - You're logged in on as the same user on both computers? Are both computers in the same domain?

Can you access the report server in a web browser from the remote computer?

If you can, try this:

in the SSMS connection dialog. Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

Does that work?

-Lukasz

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

Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine. Type in your windows credentials and see if you get the same error.

-Lukasz

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

|||

I found followings in the log file, any hint? By the way, got same error when try to connect with basic authentication. Thanks.

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

|||

Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory.

By default these are:

Report Manager: http://localhost/reports

Report Server: http://localhost/reportserver

-Lukasz

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

Did you ever find out why you couldn't just us the servername in SSMS? I am having this same problem.

Thanks,

Bryan

|||No, fine with me to use url.

Connect to remote RS in SSMS

Got following error when try to connect to remote reporting service in SSMS:

TITLE: Microsoft SQL Server Management Studio

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that? Thanks.

Odd - You're logged in on as the same user on both computers? Are both computers in the same domain?

Can you access the report server in a web browser from the remote computer?

If you can, try this:

in the SSMS connection dialog. Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

Does that work?

-Lukasz

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

Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine. Type in your windows credentials and see if you get the same error.

-Lukasz

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

|||

I found followings in the log file, any hint? By the way, got same error when try to connect with basic authentication. Thanks.

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

|||

Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory.

By default these are:

Report Manager: http://localhost/reports

Report Server: http://localhost/reportserver

-Lukasz

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

Did you ever find out why you couldn't just us the servername in SSMS? I am having this same problem.

Thanks,

Bryan

|||No, fine with me to use url.sql sql

Connect to Remote Analysis Server

Hi,

How do I connect to a remote Analysis Server using SQL management studio on my local machine.

Thanks in advance..

Hi,

At the remote computer you want to connect, your nt domain username should be at least in the MSOLAPUser group. And if you want to have server-wide permissions your username should be added to the list displayed in the security tab of the olap server properties screen.

Eralper

http://www.kodyaz.com

|||Hi eralper,

Thanks for the reply. But how can my local SQL management studio detect Analysis Services of Network Servers? As of now, it can only detect Database Engines of other network server..

Thanks again...
|||

What is the name of the physical machine you want to connect to?

Also when it was installed was the instance given a name?

If the instance was not given a name then you can just put the machine name in the server edit control, if it has a name then it should be servername\instancename in the control.

|||

Maybe the Analysis Server is not configured to allow remote connections?

1. On the remote machine, start the SQL Server Surface Area Configuration tool and verify that remote connections are enabled.

2. On the remote machine, verify that the SQL Browser windows service is running.

3. If you have the Windows Firewall enabled on the local machine or remote machine, you will need to make sure you open TCP ports so Analysis Server can accept incoming connections. The port numbers Analysis Server listens to are following:
2383 – port default instance of Analysis Server listens to
2382 – port SQL Browser service listens to for Analysis Services requests.

Note: Named instance of Analysis Services will dynamically pick ports to listen on your machine. The easiest way to discover the TCP port the named instance is listening is to look at the configuration file for SQL Server Browser file. Open file located on the %Program files%\Microsoft SQL Server\90\Shared\ASConfig. Open msmdredir.ini file and look at the < Instances> section in it.
For example you might see following in it;
<Instances>
<Instance>
<Name>Inst1</Name>
<Port>56178</Port>
</Instance>
</Instances>

This means your machinename\Inst1 is listening on the port 56178.

In many situations you would like to ensure your named instance is not picking port by itself but listens on pre-defined port. For that, you can modify the Port – Analysis Server property. Make sure you restart Analysis Server and SQL Server Browser service after changing this property.

Hope this helps,

-- Robert

|||

Hi,

If you open the SQL Server Management Studio, open the Registered Servers screen and select Analysis Services.

If you try to add a new olap server, a list of available servers are listed in the dropdownlist. Or you can use the browse button. But I guess these are not coming from a network search process for available servers.

Sorry, I don't have an answer for that.

But I can suggest a tool which scans for sql servers within an IP range, SQLPing2 by C. Andrews from sqlsecurity.com

Unfortunately this tool does not search for the MS AS instances.

Eralper

http://www.kodyaz.com

Connect to object explorer but cannot connect to Integration services.

I try to import my SSIS packages which are created using the Business Intelligent studio into SQL server 2005 but I cannot do that.

I am running SQL server 2005 enterprise edition.

Also when i tried to connect to Integration services using Object explorer, it only prompt me for server name. I cannot change the username and password which is disabled.

Then how am i supposed to connect to Integration services on a server in this case?

There is no username and password required to connect to SSIS Server.

-Jamie

|||

i got a server A...i tried to connect without password and user it gives me error....

the sql server is using sql authetication not windows authetication.

|||SQL Server authentication is for SQL Server. The SSIS Server (service) is something else and does not support SQL Server auth. You need windows auth to connect. It actually uses DCOM.|||

so how should i proceed from here?

my server wont allow me to connect to SSIS services using object explorer.

"Access is denied" connect to server 1 on machine failed.

Do i need to create anything on the server?

sql sql

Thursday, 22 March 2012

Connect to desktop database 2

Please Help me!

I hav emulator Windows CE 4.0 with Visual Studio 2003, C#.

I want connect to sql server 2000......after read all posts of this subject and try all varieties modes of connecting string.....in sql profile i see that application in emulator try to connect the sql server but i have the same exception :

PlatformNotSupportedException

Here my code:

strcon = "Server = developer\\devsql;Initial Catalog = master;User ID = domain\\login; password = ******;Integrated Security = false";

What i did wrong or may be miss something?

I have already solve this problem.....

The problem is nonconformity of collation DB and local settings of the mobile device.....

Tuesday, 20 March 2012

Connect to DB using another TCP port from SQL management Studio

Hi,
The DBA set database on server to a high TCP port number.
How can I connect to it from Microsoft SQL2005 management Studio.
I can't find the option to set TCP port number in there.
Thanks!You can use tcp:servername,port in the connection dialog although if the SQL
Browser is running you should still be able to use the instance name. As an
alternative you can set up a client alias using SQL Server Configuration
Manager>SQL Native Client Configuration>Aliases
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<walanta> wrote in message
news:loure2pjt4o6rvq7t5r3rvh4mln76i3pan@.
4ax.com...
> Hi,
> The DBA set database on server to a high TCP port number.
> How can I connect to it from Microsoft SQL2005 management Studio.
> I can't find the option to set TCP port number in there.
> Thanks!|||Where is "connection dialog" ?
I'm using SQL server management studio-> object explore-> connect->
database engine -> ...
I see "servername:", "authentication:", "connect to database:",
"network protocol"...
No place I can put "tcp:192.168.1.1,8800" or somthing like that.
On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
<jasper_smith9@.hotmail.com> wrote:

>You can use tcp:servername,port in the connection dialog although if the SQ
L
>Browser is running you should still be able to use the instance name. As an
>alternative you can set up a client alias using SQL Server Configuration
>Manager>SQL Native Client Configuration>Aliases|||Hi,
Go to SQL Server program groups nad select "SQL Server Configuration
Manager"
Thanks
Hari
SQL Server MVP
<walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@.
4ax.com...[vbcol=seagreen]
> Where is "connection dialog" ?
> I'm using SQL server management studio-> object explore-> connect->
> database engine -> ...
> I see "servername:", "authentication:", "connect to database:",
> "network protocol"...
> No place I can put "tcp:192.168.1.1,8800" or somthing like that.
>
>
> On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
> <jasper_smith9@.hotmail.com> wrote:
>|||It's in the Server name box i.e. if your server was called FOO and on port
55551 you would use
tcp:FOO,55551
in the Server name box
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@.
4ax.com...[vbcol=seagreen]
> Where is "connection dialog" ?
> I'm using SQL server management studio-> object explore-> connect->
> database engine -> ...
> I see "servername:", "authentication:", "connect to database:",
> "network protocol"...
> No place I can put "tcp:192.168.1.1,8800" or somthing like that.
>
>
> On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
> <jasper_smith9@.hotmail.com> wrote:
>|||If SQL Browser is started you should be redirected automatically. For
security reasons (and the fact that this is not enabled in the setup
process by default) the SQL Browser service can not be running. The
port can be specified manually by putting it after the instancename you
want to connect to:
For default instances: Servername\InstanceName,Portnumber
For named instances: Servername,Portnumber
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

Connect to database without showing the "Connect to Server" dialog box?

Is it possible to configure the SQL Server Management Studio to behave like good old Enterprise Manager, so that it automatically connects to my configured servers without showing the "Connect to Server" dialog box every time upon startup?

After successlessly searching Google and these forums, I still found no suitable answer to this question (maybe beside this one).

Thanks
Uwe

You ae right this is not possible, perhaps you can suggest that as a feature request on connect.microsoft.com ?

HTH, Jens Suessmeyer.

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

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=180590

Thanks, Jens .|||You got my vote.

-Jens.|||Strange - they marked the ticket as "closed" and "solved", but no further comments.

Anyone knows what this actually means? IS it already present and I did not found it? Or will it be implemented in a further version?

Thanks
Uwe

connect to an instance?

How do I connect to an instance of a database

which is in a web application (not published) with SQL server management studio express?

I seem to be able to connect to the data base created ......but not after i have added

it into my web app?

does that make sense

er found a ton of videos onit

Monday, 19 March 2012

Connect Problems with Sql Server 05 Express

Hallo,
Maybe some hints are avialable.
System: Vista Business
SQL-Server: 2005 Express SP2
UserStatus: Admin
Connect via Management Studio 05
Error: 5120 bzw. 5123 - access declined.
Datenfile is local with full access
any ideas?
regards
akko
What does the connectstring look like? Is the instance running? Are you
accessing a local instance or one on the network?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"akko" <info@.akko.at> wrote in message
news:B44FF7D8-BFA1-4556-965F-AB9E81DC7452@.microsoft.com...
> Hallo,
> Maybe some hints are avialable.
> System: Vista Business
> SQL-Server: 2005 Express SP2
> UserStatus: Admin
> Connect via Management Studio 05
> Error: 5120 bzw. 5123 - access declined.
> Datenfile is local with full access
> any ideas?
> regards akko
|||problem fixed, caused by sqlserver-service had not enaugh rights on folder.
"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> schrieb im Newsbeitrag
news:uMHrs5EjHHA.392@.TK2MSFTNGP06.phx.gbl...
> What does the connectstring look like? Is the instance running? Are you
> accessing a local instance or one on the network?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ------
> "akko" <info@.akko.at> wrote in message
> news:B44FF7D8-BFA1-4556-965F-AB9E81DC7452@.microsoft.com...
>

Connect Problems with Sql Server 05 Express

Hallo,
Maybe some hints are avialable.
System: Vista Business
SQL-Server: 2005 Express SP2
UserStatus: Admin
Connect via Management Studio 05
Error: 5120 bzw. 5123 - access declined.
Datenfile is local with full access
any ideas?
regards
akkoWhat does the connectstring look like? Is the instance running? Are you
accessing a local instance or one on the network?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"akko" <info@.akko.at> wrote in message
news:B44FF7D8-BFA1-4556-965F-AB9E81DC7452@.microsoft.com...
> Hallo,
> Maybe some hints are avialable.
> System: Vista Business
> SQL-Server: 2005 Express SP2
> UserStatus: Admin
> Connect via Management Studio 05
> Error: 5120 bzw. 5123 - access declined.
> Datenfile is local with full access
> any ideas?
> regards akko|||problem fixed, caused by sqlserver-service had not enaugh rights on folder.
"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> schrieb im Newsbeitrag
news:uMHrs5EjHHA.392@.TK2MSFTNGP06.phx.gbl...
> What does the connectstring look like? Is the instance running? Are you
> accessing a local instance or one on the network?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----
---
> "akko" <info@.akko.at> wrote in message
> news:B44FF7D8-BFA1-4556-965F-AB9E81DC7452@.microsoft.com...
>

Sunday, 11 March 2012

Connect into SSAS from SSMS with diferent user

Hi,

I'm a consultant and I need to connect to differents SSAS Servers using Management Studio.

In each customer I have one different user. I use this user to connect into their network and access servers, drives and SQL Server (using SQL autenticate) from my laptop (without connect into domain from my user).

In some customers, when I've a drive mapped to server I can access SSAS, but I don't know why this happen only in some customers and how do this again.

I'd like if someone can help me.

Thanks.

You can specify User Name and Password connection string properties when connecting to AS, (but it is possible that Management Studio doesn't have UI for them). Mapping drive works sometimes because of how NETBIOS interacts with SSPI, but in general it is not reliable way of piggibacking of establishing credentials.|||

The runas command should do what you want:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1365877&SiteID=17

Saturday, 25 February 2012

Confused about MSSQL Express installations

I have this confusion because as I am trying to install "SQL Server Management Studio Express", the installers said I already have it.

Q1. Do I need it if I already have SQL Server Management Studio for Server 2005?

Q2.

How many ways to have SQL Express installed on your PC?

- Seperate downloads

- Visual Studio 2005 Retail

- SQL Server 2005

In that regards, will all methods are basically install the same set of components into the machine?

Q3. I don't find any relevant item in the "Add or Remove Programs" regarding to SQL Express.

Is that because SQLExpress is just an database instance not a application item?

Q4. Where are the files of Express in the file system?

I saw in c:\Program files\Microsoft SQL Server, a few directories like

80, 90, MSSQL.1, MSSQL.2, MSSQL.3, MSSQL.3, MSSQL.4

Which one of those belongs to SQL Express and which belongs to SQL Server 2005?

Is the directory structure identical with other types of installation (standalone and VS IDE)?

Thanks

Stanley

If you have the full version of SQL Management studio the installer will not allow you to install the express version as it is already installed.

Each of the numbered directories refers to an instance of sql server 2005 installed on the system. The engine tool and shared files are stored inside the version directories ie 80 or 90... where 80 is sql server 2000 and 90 is sql server 2005.

|||I too have had problems re the above. I uninstalled what I had, and then reinstalled my first download of SQLexpress. I configured (re help), added in online books, searched for answers re an interface and found something on dnncreative forum re the management download. This time I was able to install it.

Sorry for not being too specific, but it all became a blurr. Perhaps you could try without configuring, if that doesnt work, youll find what you need to know online amongst the configuring ...

Confliction between SQL Server 2005 and SQL Server 2005 Express Edition

Hi,

My objective is using a single DB file (mdf file) + SQL Server Express 2005 to run my program

I got two softwares here, Visual Studio 2005 and SQL Server 2005. Firstly, I installed Visual Studio 2005, normally the SQL Server 2005 Express Edition will be installed with this software. After finishing the installation. I opened a new project and try to open a DB file (.mdf) from Visual Studio 2005, it works. The problem is that I can't restore the mdf file from an old database file since it lose a lot of functions that appear in SQL Server 2000 / SQL Server 2005. And it is too troublesome and inconvenient to edit a DB file in Visual Stuio 2005.

Therefore, I have to install SQL Server 2005 for me to edit the mdf file, so that I can modify, backup, or even restore the mdf file with another DB file. After the installation of SQL Server 2005, I got a tool, SQL Server Managment Studio, to edit the mdf file. I can open the mdf file but when I double-clicked on the mdf file in Visual Studio 2005, it gives me the following error message:

Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL:http://go.microsoft.com/fwlink/?LinkId=49251

It seems the SQL Server 2005 modify some of the files in SQL Server 2005 Express Edition. Is that SQL Server 2005 and SQL Server 2005 Express Edition cannot be exist at the same time?

The issue is I'm working on my computer, but I dun want to install SQL Server 2005 in the server that I will transfer to. It will be much like using Access DB file, without the Microsoft Access software, the program can still work well. However, when I'm still in programming stage, I do hope to have a DB file as the source file for my program, but I can do some editing works with SQL Server 2005.

Does anyone can give me a suggestion? Thanks for your kindly reply.

Calvin

On my machine I have SQL2005 and SQL Express installed at the same time, and both of them work fine. I guess the problem lays in connection string of the database. You can check as following:

Go to database explorer-data connections.
Right click your mdf database and click "modify connection"...
Click the advanced button
Search for the "data source" string
Set the string to refer to your SQL Server2005 instance.

You can take a look at this link:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124596&SiteId=1.

BTW, if you just want to operate on the database file more directly, you do not need to install SQL Server2005. You can intall "SQL Server Management Studio Express " from here:

http://msdn.microsoft.com/vstudio/express/sql/download/

Friday, 17 February 2012

Configuring SQL Express -- getting login failed exception

I have a machine with Windows XP Pro w/SP 2, IIS, SQL Server Express and Visual Studio 2005 installed. When I attempt to open a database from an ASPX page, I'm getting an exception with the message:

"Cannot open database "Tasks" requested by the login. The login failed.
Login failed for user 'MYDEV\ASPNET'."

I've searched the web and found a number of pages that talk about the "Login failed for MACHINE\ASPNET" issue, but I didn't find any with a solution.

For your information (in case it makes any difference), the computer is connected to a domain. And the authentication methods for the virtual directory (in IIS) is configured for "Anonymous access" and "Integrated Windows authentication."

Does anyone know how to configure SQL Server Express (or is it IIS?) so the web page can access the database?

RichardR

Okay, I found a solution.

For anyone else experiencing this problem, here's what I did:

First, I installed the November CTP of SQL Server Management Studio Express.

Then, I added the account MACHINENAME\ASPNET under Security | Logins. I did a right-mouse click on the ASPNET login name and clicked on Properties.

This brought up the Login Properties page for ASPNET. I mapped the ASPNET account to my database selecting the database in the "Default Database" dropdown.

In order for the stored procedures to execute, I also needed to check the db_owner box under the Mappings tab.

Finally, I needed to change the connection string to:

Data Source=MYDEV\SQLEXPRESS;Connect Timeout=30;User Instance=False;initial catalog=Tasks;Integrated Security=SSPI;Persist Security Info=False

Hope this helps anyone else encountering this problem.

Richard

|||Thanks - that was very helpful!!!
|||Thanks for the post! Saved my life after hours of searching!!!

Configuring SQL Express -- getting login failed exception

I have a machine with Windows XP Pro w/SP 2, IIS, SQL Server Express and Visual Studio 2005 installed. When I attempt to open a database from an ASPX page, I'm getting an exception with the message:

"Cannot open database "Tasks" requested by the login. The login failed.
Login failed for user 'MYDEV\ASPNET'."

I've searched the web and found a number of pages that talk about the "Login failed for MACHINE\ASPNET" issue, but I didn't find any with a solution.

Does anyone know how to configure SQL Server Express (or is it IIS?) so the web page can access the database?

RichardR

Okay, I found a solution.

For anyone else experiencing this problem, here's what I did:

First, I installed the November CTP of SQL Server Management Studio Express.

Then, I added the account MACHINENAME\ASPNET under Security | Logins. I did a right-mouse click on the ASPNET login name and clicked on Properties.

This brought up the Login Properties page for ASPNET. I mapped the ASPNET account to my database selecting the database in the "Default Database" dropdown.

In order for the stored procedures to execute, I also needed to check the db_owner box under the Mappings tab.

Finally, I needed to change the connection string to:

Data Source=MYDEV\SQLEXPRESS;Connect Timeout=30;User Instance=False;initial catalog=Tasks;Integrated Security=SSPI;Persist Security Info=False

Hope this helps anyone else encountering this problem.

Richard

|||Thanks - that was very helpful!!!
|||Thanks for the post! Saved my life after hours of searching!!!

Configuring SQL Express -- getting login failed exception

I have a machine with Windows XP Pro w/SP 2, IIS, SQL Server Express and Visual Studio 2005 installed. When I attempt to open a database from an ASPX page, I'm getting an exception with the message:

"Cannot open database "Tasks" requested by the login. The login failed.
Login failed for user 'MYDEV\ASPNET'."

I've searched the web and found a number of pages that talk about the "Login failed for MACHINE\ASPNET" issue, but I didn't find any with a solution.

Does anyone know how to configure SQL Server Express (or is it IIS?) so the web page can access the database?

RichardR

Okay, I found a solution.

For anyone else experiencing this problem, here's what I did:

First, I installed the November CTP of SQL Server Management Studio Express.

Then, I added the account MACHINENAME\ASPNET under Security | Logins. I did a right-mouse click on the ASPNET login name and clicked on Properties.

This brought up the Login Properties page for ASPNET. I mapped the ASPNET account to my database selecting the database in the "Default Database" dropdown.

In order for the stored procedures to execute, I also needed to check the db_owner box under the Mappings tab.

Finally, I needed to change the connection string to:

Data Source=MYDEV\SQLEXPRESS;Connect Timeout=30;User Instance=False;initial catalog=Tasks;Integrated Security=SSPI;Persist Security Info=False

Hope this helps anyone else encountering this problem.

Richard

|||Thanks - that was very helpful!!!|||Thanks for the post! Saved my life after hours of searching!!!

Sunday, 25 March 2012

connect to server name 2005!

Connect to Remote SQL SERVER Express 2005 server

Connect to Remote SQL SERVER Express 2005 server

Connect to remote RS in SSMS

Connect to remote RS in SSMS

Connect to remote RS in SSMS

Connect to Remote Analysis Server

Connect to object explorer but cannot connect to Integration services.

Thursday, 22 March 2012

Connect to desktop database 2

Tuesday, 20 March 2012

Connect to DB using another TCP port from SQL management Studio

Connect to database without showing the "Connect to Server" dialog box?

connect to an instance?

Monday, 19 March 2012

Connect Problems with Sql Server 05 Express

Connect Problems with Sql Server 05 Express

Sunday, 11 March 2012

Connect into SSAS from SSMS with diferent user

Saturday, 25 February 2012

Confused about MSSQL Express installations

Confliction between SQL Server 2005 and SQL Server 2005 Express Edition

Friday, 17 February 2012

Configuring SQL Express -- getting login failed exception

Configuring SQL Express -- getting login failed exception

Configuring SQL Express -- getting login failed exception

SQL Configure

Blog Archive

About Me