Connecting to SQL 2005 Server via VPN

Hi all,
I am unable to connect to SQL2005 server using the Management Studio. i can
however connect to SQL2000 using EM. Has anyone else encoutered this issue?
if so could you please share the solution? what is ti that i need to enable
on the firewall?
Thanks
JoresIs SQL Server 2005 enabled for remote connections?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"joresm" <joresm@.hotmail.com> wrote in message
news:ODgXkoKaGHA.1220@.TK2MSFTNGP02.phx.gbl...
> Hi all,
> I am unable to connect to SQL2005 server using the Management Studio. i
> can however connect to SQL2000 using EM. Has anyone else encoutered this
> issue? if so could you please share the solution? what is ti that i need
> to enable on the firewall?
> Thanks
> Jores
>|||Yes, it is enabled and the Browser sevice is also running. i canconnect to
it using the query analyzer. the only problem is with Management studio.
Thanks
Jores
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uBvNIgLaGHA.1348@.TK2MSFTNGP05.phx.gbl...
> Is SQL Server 2005 enabled for remote connections?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "joresm" <joresm@.hotmail.com> wrote in message
> news:ODgXkoKaGHA.1220@.TK2MSFTNGP02.phx.gbl...
>|||Hi I have experienced this problem also. Spent best part of a day trying to
resolve this to no avail. We have a VPN connection to our data center. The
database server has an instance of SQL 2000 which runs fine locally and
remotely from my desk. Recently we installed SQL 2005 and want to migrate
stuff to this new named instance. I can connect to the database fine locally
(on the database server itself and from other colocated machines (via
ADO.net). However I cannot access SQL 2005 over the VPN connection using
either ADO.net test app or SQL Management Studio. Is there some kind of port
blocking going on?
I don't know anything about Named Pipes, but I've tried the SQL
Configuration tool as suggested in some articles and have tried setting the
port to 1433 and turning of SQL 2000 to no avail. Would the VPN somehow be
blocking some ports - it appears that way, but my administrator assures me
that I should have full spectrum of ports available. WHATS GOING ON' Is the
SQL browser getting blocked or what? What button do I need to push to get
access to my database server from my development machine located over the
VPN?
Thanks Rob
"joresm" wrote:

> Yes, it is enabled and the Browser sevice is also running. i canconnect to
> it using the query analyzer. the only problem is with Management studio.
> Thanks
> Jores
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uBvNIgLaGHA.1348@.TK2MSFTNGP05.phx.gbl...
>
>

Connecting to SQL 2005 Server via VPN

Hi all,
I am unable to connect to SQL2005 server using the Management Studio. i can
however connect to SQL2000 using EM. Has anyone else encoutered this issue?
if so could you please share the solution? what is ti that i need to enable
on the firewall?
Thanks
JoresIs SQL Server 2005 enabled for remote connections?
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"joresm" <joresm@.hotmail.com> wrote in message
news:ODgXkoKaGHA.1220@.TK2MSFTNGP02.phx.gbl...
> Hi all,
> I am unable to connect to SQL2005 server using the Management Studio. i
> can however connect to SQL2000 using EM. Has anyone else encoutered this
> issue? if so could you please share the solution? what is ti that i need
> to enable on the firewall?
> Thanks
> Jores
>|||Yes, it is enabled and the Browser sevice is also running. i canconnect to
it using the query analyzer. the only problem is with Management studio.
Thanks
Jores
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uBvNIgLaGHA.1348@.TK2MSFTNGP05.phx.gbl...
> Is SQL Server 2005 enabled for remote connections?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "joresm" <joresm@.hotmail.com> wrote in message
> news:ODgXkoKaGHA.1220@.TK2MSFTNGP02.phx.gbl...
>> Hi all,
>> I am unable to connect to SQL2005 server using the Management Studio. i
>> can however connect to SQL2000 using EM. Has anyone else encoutered this
>> issue? if so could you please share the solution? what is ti that i need
>> to enable on the firewall?
>> Thanks
>> Jores
>|||Hi I have experienced this problem also. Spent best part of a day trying to
resolve this to no avail. We have a VPN connection to our data center. The
database server has an instance of SQL 2000 which runs fine locally and
remotely from my desk. Recently we installed SQL 2005 and want to migrate
stuff to this new named instance. I can connect to the database fine locally
(on the database server itself and from other colocated machines (via
ADO.net). However I cannot access SQL 2005 over the VPN connection using
either ADO.net test app or SQL Management Studio. Is there some kind of port
blocking going on?
I don't know anything about Named Pipes, but I've tried the SQL
Configuration tool as suggested in some articles and have tried setting the
port to 1433 and turning of SQL 2000 to no avail. Would the VPN somehow be
blocking some ports - it appears that way, but my administrator assures me
that I should have full spectrum of ports available. WHATS GOING ON' Is the
SQL browser getting blocked or what? What button do I need to push to get
access to my database server from my development machine located over the
VPN?
Thanks Rob
"joresm" wrote:
> Yes, it is enabled and the Browser sevice is also running. i canconnect to
> it using the query analyzer. the only problem is with Management studio.
> Thanks
> Jores
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uBvNIgLaGHA.1348@.TK2MSFTNGP05.phx.gbl...
> > Is SQL Server 2005 enabled for remote connections?
> >
> > --
> > Hilary Cotter
> > Director of Text Mining and Database Strategy
> > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> >
> > This posting is my own and doesn't necessarily represent RelevantNoise's
> > positions, strategies or opinions.
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> >
> >
> >
> > "joresm" <joresm@.hotmail.com> wrote in message
> > news:ODgXkoKaGHA.1220@.TK2MSFTNGP02.phx.gbl...
> >> Hi all,
> >> I am unable to connect to SQL2005 server using the Management Studio. i
> >> can however connect to SQL2000 using EM. Has anyone else encoutered this
> >> issue? if so could you please share the solution? what is ti that i need
> >> to enable on the firewall?
> >>
> >> Thanks
> >> Jores
> >>
> >
> >
>
>sqlsql

connecting to server from SQL Server Management Studio

Hi,

I have 2 servers (test ,preprod ) with sql2005 and reporting services

Using SQL Server Management Studio I can connect on reporting services on test server

specifying server name http://smcanSQL10-tst/reportserver or smcanSQL10-tst

but for preprod server I have to specify

http://smcanSQL10-ppd/reportserver

if I simply put smcanSQL10-ppd application raise error

The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)

Is any setting missiing in my server configuration?

Alex,

Have you checked in your SQL 2005 Reporting Service Configuration manager under the "Report Server Virtual Directory" to make sure that the name is corrected?

Ham

|||

yes,

on both servers it is

name: ReportServer

Website: Defaut Web Site

sqlsql

Connecting to ODBC Connections with Report Services

I have just migrated from SQL 2000 to SQL 2005 and in the process upgraded to new hardware. I am now running SQL2005 (64 Bit) on Windows 2003 R2 (64 Bit). The problem is that when i deploy some reports to the new server that use ODBC to connect to the data, reporting services is erroring with :

Data source name not found and no default driver specified

The ODBC connections are set up exactly the same on the old server and the new server. Is it because it is looking for a 64 bit ODBC driver and not the 32 Bit one I have installed. If i go into the SysWOW64 and run the odbcad32.exe i can see the drivers and the connection. The connection test works fine from here.

Thanks

Has anyone got any ideas on this ?|||Did you find a resolution? I have the same problem.|||I am waiting for a company called Openlink to get back to me they are currently developing some drivers|||Thanks. My client is switching to 32-bit software to resolve this. Good luck.|||

Did anyone get this resolved? I am having the same problem. I fear I may have to revert back to the 32-Bit OS.

Any advice or suggestion are welcomed.

Thanks,

Andy

Connecting to ODBC Connections with Report Services

I have just migrated from SQL 2000 to SQL 2005 and in the process upgraded to new hardware. I am now running SQL2005 (64 Bit) on Windows 2003 R2 (64 Bit). The problem is that when i deploy some reports to the new server that use ODBC to connect to the data, reporting services is erroring with :

Data source name not found and no default driver specified

The ODBC connections are set up exactly the same on the old server and the new server. Is it because it is looking for a 64 bit ODBC driver and not the 32 Bit one I have installed. If i go into the SysWOW64 and run the odbcad32.exe i can see the drivers and the connection. The connection test works fine from here.

Thanks

Has anyone got any ideas on this ?|||Did you find a resolution? I have the same problem.|||I am waiting for a company called Openlink to get back to me they are currently developing some drivers|||Thanks. My client is switching to 32-bit software to resolve this. Good luck.|||

Did anyone get this resolved? I am having the same problem. I fear I may have to revert back to the 32-Bit OS.

Any advice or suggestion are welcomed.

Thanks,

Andy

Connecting to ODBC Connections with Report Services

I have just migrated from SQL 2000 to SQL 2005 and in the process upgraded to new hardware. I am now running SQL2005 (64 Bit) on Windows 2003 R2 (64 Bit). The problem is that when i deploy some reports to the new server that use ODBC to connect to the data, reporting services is erroring with :

Data source name not found and no default driver specified

The ODBC connections are set up exactly the same on the old server and the new server. Is it because it is looking for a 64 bit ODBC driver and not the 32 Bit one I have installed. If i go into the SysWOW64 and run the odbcad32.exe i can see the drivers and the connection. The connection test works fine from here.

Thanks

Has anyone got any ideas on this ?|||Did you find a resolution? I have the same problem.|||I am waiting for a company called Openlink to get back to me they are currently developing some drivers|||Thanks. My client is switching to 32-bit software to resolve this. Good luck.|||

Did anyone get this resolved? I am having the same problem. I fear I may have to revert back to the 32-Bit OS.

Any advice or suggestion are welcomed.

Thanks,

Andy

Connecting to DB Engine

I am running a mirrored database using SQL2005 and whether or not mirroring has anything to do with this has not been determined. Often when a failover is necessary we are in a state where the active server responds just enough to show existence but not enough to determine database state. The SQL Management Studio can not connect to the server and the exception report from our application has the following message:

<exception type="System.Data.SqlClient.SqlException">

<message>A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)</message>
<source>.Net SqlClient Data Provider</source>
<target>System.Data.ProviderBase.DbConnectionPool::GetConnection</target>
<stack>

<trace index="0">at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)</trace>
<trace index="1">at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)</trace>
<trace index="2">at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)</trace>
<trace index="3">at System.Data.SqlClient.SqlConnection.Open()</trace>
<... application stack/>
</stack>

</exception>

When this happens, the the SqlClient does not fail over to the mirror until we stop the service on the failed SQL server. Sometimes, the mirror server doesn't full pick up until we stop the service on the failed server.

Today, out of curiosity I attemped to connect to port 1433 using TelNet to see if the server was even listening at the standard endpoint anymore (before I received the Exception Report above). It was. So how do I determine what is happening that causes the connections to close, and if at all possible - prevent it?

Thanks in advance for any advice you may have.

-Dave

Server Version:

Microsoft SQL Server 2005 - 9.00.3042.00 (X64)

Feb 10 2007 00:59:02

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

HI Dave,

Check for the following,

1.) Check the login whether it has necessary privileges on the database(default db for the login) its going to connect. Since the error shows its connected to the server and not to the default db.

2.) Check on which port Sqlserver is listening then connect using the port as servername,portno.

If possible post Errorlog & Eventlog info....
|||

Vidhya,

Yes. The login does have the rights and it is connecting to the correct port. When this occurs we (the DB admins) can not even connect via SQL Management Studio. We have to shut the service down via the Service Control Manager in Windows.

-Dave

Connecting to DB Engine

I am running a mirrored database using SQL2005 and whether or not mirroring has anything to do with this has not been determined. Often when a failover is necessary we are in a state where the active server responds just enough to show existence but not enough to determine database state. The SQL Management Studio can not connect to the server and the exception report from our application has the following message:

<exception type="System.Data.SqlClient.SqlException">

<message>A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)</message>
<source>.Net SqlClient Data Provider</source>
<target>System.Data.ProviderBase.DbConnectionPool::GetConnection</target>
<stack>

<trace index="0">at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)</trace>
<trace index="1">at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)</trace>
<trace index="2">at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)</trace>
<trace index="3">at System.Data.SqlClient.SqlConnection.Open()</trace>
<... application stack/>
</stack>

</exception>

When this happens, the the SqlClient does not fail over to the mirror until we stop the service on the failed SQL server. Sometimes, the mirror server doesn't full pick up until we stop the service on the failed server.

Today, out of curiosity I attemped to connect to port 1433 using TelNet to see if the server was even listening at the standard endpoint anymore (before I received the Exception Report above). It was. So how do I determine what is happening that causes the connections to close, and if at all possible - prevent it?

Thanks in advance for any advice you may have.

-Dave

Server Version:

Microsoft SQL Server 2005 - 9.00.3042.00 (X64)

Feb 10 2007 00:59:02

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

HI Dave,

Check for the following,

1.) Check the login whether it has necessary privileges on the database(default db for the login) its going to connect. Since the error shows its connected to the server and not to the default db.

2.) Check on which port Sqlserver is listening then connect using the port as servername,portno.

If possible post Errorlog & Eventlog info....
|||

Vidhya,

Yes. The login does have the rights and it is connecting to the correct port. When this occurs we (the DB admins) can not even connect via SQL Management Studio. We have to shut the service down via the Service Control Manager in Windows.

-Dave

connecting to an SQL2005 Server

Hi

I am trying to upgrade a system from SQL 2000 to SQL2005.

I have installed the Server on a PC with Win XP SP2. Using another PC (also Win XP SP2) on the LAN I need to ODBC to the Server.

The Server is NOT the default instance.

I cannot connect via ODBC from the Client PC. This all worked fine with SQL 2000.

As a test I also tried a fresh install of SQL2005 where it was the default instance, this worked fine.

SO the problem is when you have multiple instances.

What do I have to do to sort it out?

Cheers

Eugene

Hi,

What is a error message !? Untill you provide error message we cannot suggest you answer.

Hemantgiri S. Goswami

|||

The error is

Cannot connect to Fred\Fredsql

SQL server does not allow remote connections etc, SQL error 10060

I have used the Surface Area program and Allow remote connections is ticked

Cheers

Eugene

|||Did you had a look in the surface area for this particular instance ? These settings are configured per instance and therefore if you enabled remote connections for the default instance, it does not mean that it is enabled for the named instance as well.

HTH, jens K. Suessmeyer.

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

There are three things that you need to check for...

1) Insure remote connections is enabled for your database instance via the Surface Area Configuration tool for the named instance you are using. By default, SQL Express and DEV SKU has this disabled. Based on the error message posted, this seems to be the issue.

2) Since you are using a non-default (named) instance, this requires that the SQL Browser service to be configured and running properly.

3) Also on Windows XP SP2, you need to insure the firewall exceptions are set up properly. Here is a link with information on how to do this...

http://support.microsoft.com/default.aspx/kb/841249

Hope this helps,

Tom

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

Connecting SQL2005 from older C++ client - the solution was ...

After setting up
SQL2005express server with
mixed authentification I got the problem

1. I couldnt find a working ConnectionString
2. Studio2005 didnt connect to SQL any more

In the meantime I found that at least the following OLEDB-ConnectionString is working, when Im logged in as admin and can use Windows Autentication:

Provider='sqloledb'
Data Source='.' - without '/SQLEXPRESS' !!
Initial Catalog='MyDatabaseName'
Integrated Security='SSPI'

For details of SQL setup and code to test possible connetion strings
please see my homepage.
Martin
text of my question from 02 Dec 2005
I want to feed data of a C++ 6.0 project into SQL server and hoped that StudioExpress would give me the correct connection string in detail.
But my StudioExpress doesnt conntect to a SQL server configured for SQL-Authentication.
I made screenshote of the details an put them in subfolders of my homepage
http://home.arcor.SQL2005.
Does anybody know what exact connection string has to be used and which changes in StudioExpress AdvancedConnectionProperties are necessary to establish a working connection?

The above link contains a collection of screenshots with details of the problem.
In the meantime I did a standard setup of the whole StudioExpress2005 C# paket and put screenshots on my homepage where you can see the difference between standard setup and single SQLExpress setup in SQL-Authentication mode.
Martin

Connecting SQL2000 problem

Hi All,

I have a sqlserver 2000 & 2005 both installed on same server with the instance name as servername\sql2000 and servername\sql2005.

When i try to connect the sql2000 database from dotnet2002 or 2003, It comes up with an error as sql server doesnot exist or access denied but when i tried with dotnet2005, i am able to connect it.

I guess it has to do with an dotnet framework 1.0 & 1.1 but i am not sure where to look for it.

Can someone please point me to right direction ?

Thanks

Shaik Nagul

on the client, check that the TCP protocols are enabled using the Client Network Utility (cliconfig.exe) and on the server there is the analog Server Network Utility (svrnetcn.exe)|||

Hi,

Thanks for the reply.

I have checked on both client and server, the tcp/ip protocol is enabled and the default port is set to 1433.

But I am still unable to connect to sqlserver.

Anymore any ideas.

Thanks

|||

for a sanity check. . .

look at services control panel applet connected to the server.

does it say:

MSSQL$SQL2000

or

MSSQLSERVER$SQL2000

?

|||

I need to look closer at these posts - I bet it does say one of the above.

ok, are you using SQLClient in 2003? or OleDB?

what does your connection string look like for the 2003 connection?

SQL Authentication or SSPI?

|||

i am using sqlclient to access the database from both 2002 and 2003. My connection string is as

objCon.ConnectionString = "server=devserver\sql2000;database=northwind;uid=sa;pwd=;"

and in the services it does say

MSSQL$SQL2000

Thanks

|||

first compare that connection string to the other connection string.

isnt it supposed to look like:

Data Source=devserver\sql2000;Initial Catalog=northwind;Password=12abc12;User ID=sa;

are you running sql server authentication?

I bet there is an sa password you need (especially if this is a sp3a or above)

Do you have a windows domain? If you do, add your windows account to SQL Server as a db admin (Or make yourself a local administrator on the machine) and use the following:

Integrated Security=SSPI;Initial Catalog=northwind;Data Source=devserver\sql2000;

|||

Please refer to

http://blogs.msdn.com/sql%5Fprotocols/

There are several very useful articles for connectivity trouble-shooting.

It is really bizarre that you can connect using net2.0, but not net1.0. Since you can connect using net2.0 with the same connection string, the problem should be on the client side. To isolate the problem,

0. Is this remote connection or local connection?

1. please verify which connection provider is used by net2.0 by issuing following query after connected, "select net_library from sysprocesses where spid=@.@.spid". I would expect it is either TCP( remote ) or LPC (local).

2. Either case, I would like you to try more explicit connection string by replacing "devserver\sql2000" with "tcp:devserver:tcpport", and try connectioin using dotnet1.0.

You should be able to find the tcp port number that ss2k is listening in either server ERRORLOG or server side registry. According to your post, I assume TCP is enabled on both server and client, especially dotnet1.0 client.

for example, in server ERRORLOG

2006-01-17 11:54:53.86 server SQL server listening on XXXXXXXX: 1433.
2006-01-17 11:54:53.89 server SQL server listening on XXXXXXXX: 1433.

The registry key of TCP port should be located under

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\sql2000\MSSQLServer\SuperSocketNetLib\Tcp.

If you can connect, then there is an issue translating connection string. We need to take further action to diagnose the issue.

Please post your test results.

|||

As far as i think, the problem exist on the server because from the same machine i am able to connect to another sqlserver which doesn't have sql2005.

Thanks guys for trying to help but i have formatted the machine and reinstall the sqlserver2000 and now everything works fine. I would have not done this if there is no time constraint but since we are working on deadlines i have to do that.

Connecting Management Studio 2005 to Analysis Manager 2000 (Sql2005 to Sql2000)

I can't connect from Management Studio 2005 (Sql2005) to Analysis Manager 2000 (Sql2000), from a remote pc, but AM 2000 to AM 2000 yes i can... my user is included in OLAP group in server with Analysis Manager 2000...

thanks for your comments

Connecting from SQL Management studio to AS 2000 is not supported. You should use AS2000 tools for that.

You will find quite a bit information on the differences of AS2000 and AS2005. In short the differences are so big, you better off using Analysis Manager to administer AS2000.

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

Connecting from iis5 ASP.net2.0 to sql2005

I'm trying to move an application I wrote from sql2000 to sql2005. The application is in ASP.NET and works fine using SQL2000 but when I moved the database and change the connect string the page display the message:

Cannot open database "EventTracker" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

If I add the identify tag to the web.config file

<identity impersonate="true" username="myname" password="mypasword"/>

then page comes up and everything works. The problem is I need to have the user's credentials from internet explorer to be used against the SQL database to control access.

I added some lines of code to see if the web page was acting with the web users credientials and it is for things other than the SQL2005 connections.

The following error message shows up in the web server's application log:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/6/2007 6:50:10 PM
Event time (UTC): 7/7/2007 12:50:10 AM
Event ID: c3d90a99419f49ad8d307930acb5bb71
Event sequence: 13
Event occurrence: 2
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/ComputerServices/TruckerViewer-9-128282421386484375
Trust level: Full
Application Virtual Path: /ComputerServices/TruckerViewer
Application Path: c:\inetpub\wwwroot\ComputerServices\TruckerViewer\
Machine name: webserver
Process information:
Process ID: 960
Process name: aspnet_wp.exe
Account name: webserver\ASPNET
Exception information:
Exception type: SqlException
Exception message: Cannot open database "EventTracker" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Request information:
Request URL: http://serverws/ComputerServices/TruckerViewer/Counters.aspx
Request path: /ComputerServices/TruckerViewer/Counters.aspx
User host address: 10.10.17.187
User: $PCA\User4
Is authenticated: True
Authentication Type: NTLM
Thread account name: webserver\ASPNET
Thread information:
Thread ID: 1
Thread account name: webserver\ASPNET
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at TruckerViewer.Counter1.Page_PreRender(Object sender, EventArgs e) in \\webserver\c$\Inetpub\wwwroot\ComputerServices\TruckerViewer\Counters.aspx.vb:line 61
at System.Web.UI.Control.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

The SQlserver's application log records two messages;

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 10.10.94.136]

and

Login succeeded for user 'NT AUTHORITY\ANONYMOUS LOGON'. Connection: trusted. [CLIENT: 10.10.94.136]

This exact same code works with SQL2000 but not with SQL2005. What am I missing? Any help would be appreciated.

If you want to use the credentials supplied by the user (through internet explorer), make sure the application is setup to use Windows Authentication.

Authentication Settings:

http://samples.gotdotnet.com/quickstart/aspplus/doc/authandauth.aspx

Also make sure you are setup for Impersonation:

http://samples.gotdotnet.com/quickstart/aspplus/doc/impersonation.aspx

The fact that the login failed for the Anonymous Login account tells me your configuration isn't quite correct (for what you are trying to do).

Evan

|||As you already turned on impersonation, you will have to configure your website NOT to use anonymous connection as this is always prefered before using authenticated connections.

Jens K. Suessmeyer.

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

That's not working... The idea is that the web "internet explorer" user's domain\account are to be used by the web server to gain access to the SQL database on another server. This isn't happeining. If I add code on the web server to reference a file on the web server that on the "internet explorer" client's account has access to, it works. If I deny access to that file for that web user they don't get access. So I think "impersonation" is working. However, when that file is stored on another computer (via a network share) the other computer complains that the "anonymous user" doesn't have access. If I grant the anonymous account access it works but I don't want anonymous users to have access, only those users who have access to the file (or in reality the SQL database). Is there something I need to do to enable the web user's account to pass through the web server to the SQL server? Can this be done at all?

|||

As Jens mentioned, you will want to disable anonymous connection for the web site/page in IIS that's hosting your ASP.Net code. This is on top of configuring your ASP.NET application to support Integrated authentication and impersonation. You can change the web site configuration using the IIS manager tool.

HTH,

Jimmy

Connect vb express to SQL2005 Developer ed?

Excuse the cross post (to VBexpress fourum) but maybe someone here will have a different take?

have searched all around can't seem to see how to configure a SQL2005 developer ed so I can use vb express to develop a local front end. keep getting "the user instance login flag is not supported on this version of sql server" I have configured the .net framework via aspnet_regsql.exe. Also I configured the "Machine.config" file. but so far no luck.

Selecting sql2005 as the server thru the add new database connection in advanced area yields the error message

surely there is away.

So far still no joy,

While Scotty indicates that the connection to SQL2005 is intentionally hampered other posters indicate that the user instance problem can be solved by running the .net config tool to add the asp database to sql server, which I have done.

However this does not yet work.

I cannot get the code to spark yet.

Again my configuration cannot be any simpler. sql express sp1 and sqldeveloper on the same machine using windows security (all installed with default cofigurations)

In the absence of other ideas I may try to get sql express downloaded and going, I'm not sure what issues that will present re: what I'm trying to develop.

I'm trying to develop the skills to replace some fairly involved reporting and some user table interface that I had going in access2003, I hate to pruchace a big piece of sw when I don't know if it will remove the current roadblocks...

Appreciate the help here, but doesn't someone have a "simpler" complete answer? I.e. one that would get the developer database to accept the connection wizard? (user instance issue)

Hi,

1). Are you able to Log In using Windows User Login credential on your SQL Server machine?

2). Have you cross check connection string?! Refer http://www.connectionstrings.com/

3). Is remote access , tcp/ip,named pipe are enabled and running properly?

4). SQL Server Browser service is running ?

5). Have check for any dependency service has problem?

6). RPC Service is running?

7). Have you check with Firewall settings?

8). Can both machine (Server/Client) ping each other?

9). What error message you got ?

Hemantgiri S. Goswami

|||

The following answers and eliminates many of the questions you pose...

I guess that MS doesn't want this envionment option to exist?

If you could answer I think it would solve a number of hanging queries.

Thank you for responding, I have temporarily given up on this quest since I have to get some real work done! ;') I went ahead and downloaded sql express and fidled a bit and now have it running with vb express and sql developer but it appears that the barriers are fairly high between the two enviornments...

Assume I want to start from scratch, one machine.....

Not answereing your questions precisely but asking a new one. With everthing operating on one machine under windows authentication using the default installation options for each product, what would be the correct (best) way to get the vb express to talk to sql developer?

Also it would be great to have the sql management studio be able to move the tables between the two environments...

All I'm trying to do is get the "best" developoment environment I can at a low cost.

|||

hi,

tomdart wrote:

Excuse the cross post (to VBexpress fourum) but maybe someone here will have a different take?

have searched all around can't seem to see how to configure a SQL2005 developer ed so I can use vb express to develop a local front end. keep getting "the user instance login flag is not supported on this version of sql server" I have configured the .net framework via aspnet_regsql.exe. Also I configured the "Machine.config" file. but so far no luck.

...

Appreciate the help here, but doesn't someone have a "simpler" complete answer? I.e. one that would get the developer database to accept the connection wizard? (user instance issue)

Visual Studio Express editions designers are "designed" to use only "file based" connections and thus User Instances features... you can connect to SQL Server engine (Developer edition as well), but only by code and not via the designers..

regards

|||

Andrea Montanari wrote:

hi,

tomdart wrote:

Excuse the cross post (to VBexpress fourum) but maybe someone here will have a different take?

have searched all around can't seem to see how to configure a SQL2005 developer ed so I can use vb express to develop a local front end. keep getting "the user instance login flag is not supported on this version of sql server" I have configured the .net framework via aspnet_regsql.exe. Also I configured the "Machine.config" file. but so far no luck.

...

Appreciate the help here, but doesn't someone have a "simpler" complete answer? I.e. one that would get the developer database to accept the connection wizard? (user instance issue)

Visual Studio Express editions designers are "designed" to use only "file based" connections and thus User Instances features... you can connect to SQL Server engine (Developer edition as well), but only by code and not via the designers as all editions but SQLExpress do not support User Instances..

regards

|||

Just to give "official" confirmation to what Andrea has already indicate, and provide more detail...

VS Express Editions are designed to work exclusively with SQL Express in terms of creating database through the UI and including them into your project. To this end, the following is true:

When you create a database using the VS Express UI, VS verifies the version of SQL being accessed is SQL Express. Any other version will fail.|||Thanks for the confirmation, I'm only doing development, learning and testing, but the signifigant restrictions of express and developer seem to make it pretty difficult. E.G. no effective import to express and no language (VB) in developer. Hence the need to use both to develop.|||

Hi tomdart,

If you want to import from Access I suggest you check out the Migration Assistant for Access that was recently released. This will get your Access data into SQL.

Mike

|||

Thank you for your reply, the following presented in the spirit of constructive feedback.

What I was hoping to do was simply import a text file, csv which is no problem with access, but simply cannot be done in sql express. I have managed , after hours to get the import going in sql developer since I can see and modify the package, but the lousy import and poor design of defaults makes the text import of express vitually a deal killer for my use. I may resort to import to access then import to express, but that seems like a sub optimal solution! I would add that native ssis in sql-developer is no champ to work with either. I don't get why the sophisticated folks at msft could not have either ssis or text import of SQL work as intellegently as Access. It seems that the defaults and error handeling just arn't as well set up, perhaps a "default mode" (which could be more intellegent or forgiving) of some sort could be added? As it now stands I regard this area as the "worst" from an everyday use perspective.

As to SSIS in sql developer, (and hence the big sql) I can't even find good doccumentation on how to modify a wizzard generated ssis package, The generated XML appears to be fairly inscrutable, and undoccumented.

|||

Hi tomdart,

Thanks for the feedback. I wasn't here when they made the decision to remove Import/Export from Express and I'm working to having at least in import solution in the next version. Your comments will help support my claim.

As another alternative I can suggest the BCP utility which can handle import and export of text based data.

Mike

Connect to SQL2000 & SQL 2005

Our current program use ADO to connect oto SQL2000 and run fine.
We are planning to migrate to SQL2005.
When we clean install the SQL2005, create the database, set compatibility
level to 80 and generate the db structure, and migrate data.
When everything is done, we try to use our program to connect to SQL2005
database and find the connection fail.
Even when we use sa as login user and still fail to connect.
Is there any different in connection for SQL2000 & SQL2005?
I remember I have tried upgrade SQL2000 to SQL2005 before and the connection
had no problem to sql2005.
Is there something I forgot to set?
KanAm Tue, 29 Aug 2006 17:38:51 +0800 schrieb Ivan:

> Our current program use ADO to connect oto SQL2000 and run fine.
> We are planning to migrate to SQL2005.
> When we clean install the SQL2005, create the database, set compatibility
> level to 80 and generate the db structure, and migrate data.
> When everything is done, we try to use our program to connect to SQL2005
> database and find the connection fail.
> Even when we use sa as login user and still fail to connect.
> Is there any different in connection for SQL2000 & SQL2005?
> I remember I have tried upgrade SQL2000 to SQL2005 before and the connecti
on
> had no problem to sql2005.
> Is there something I forgot to set?
> Kan
If you did a standard installation then SQL2005 uses the named instance
SQLExpress wich you have to use in your connect string.
If your SQL2005 runs on the same machine as your SQL2000 then maybe SQL2005
listen on another port than the standard port.
And have you allowed remote access in SQL2005?
bye, Helmut|||No, MDAC will work fine with the SQL Server 2005 instance. Although you
can=B4t use some of the new cool features its compatible. Which error do
you get ? Is the SQL Server 2k5 located on the same machine as the 2k
instance ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--