473,219 Members | 1,453 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,219 software developers and data experts.

Help me in Specifying Connection string to SQL server 2000 running on remote machine

Hi All

I am dealing a project in ASP.NET in which I have to establish a connection
to SQL Server 2000 database,where the database was located on a remote
system.
For this I have used SQLConnection object and specified the connetion
string.But when it comes to establish a connection its giving me the Error
that

I. Connection string : workstation id=localhost;packet size=4096;user
id=sa;data source=192.168.0.106;persist security info=False;initial
catalog=db

Error : System.Data.SqlClient.SqlException: Login failed for user 'sa'.
Reason: Not associated with a trusted SQL Server connection.

then I have inserted one new attribute 'Network = dbmssocn' and modified
the connection string as below

II. Connection string : workstation id=localhost;packet size=4096;user
id=sa;data source=192.168.0.106;Network=DBMSSOCN;persist security
info=False; initial catalog=db

then I got the below Error when try to establish a connection.

Error : System.Data.SqlClient.SqlException: SQL Server does not exist or
access denied

Note:

1. Here the client machine has VS.NET and IIS installed on it and the SQL
Server 2000 is running on a remote machine but both are in the same
"Workgroup network".

2.The authentication mode of the SQL Server 2000 is Mixed Authentivation(SQL
Server and Windows)

3.Firewall is also enabled on the remote machine where the SQL Server 2000
is ruuning,

4.Both Client and Server running on Windows Xp OS with SP2 installed.

Hence,I am requesting you people to help in specifying the correct
connection string(I mean where I have done the mistake)so that I can
establish a connection.

5.One more issue is that its working fine when as desktop application(i.e, I
am able to extablish connection from a desktop application done in
VB.NET,but wasn't working in web application.)Please let me know my
mistake...........as I have gone through so many forums and didn't find
solution for this.

Thanks in advance
Vighneswar
Nov 19 '05 #1
1 2249
http://www.connectionstrings.com

"vighnesh" <vi******@nannacomputers.com> wrote in message
news:eA*************@TK2MSFTNGP11.phx.gbl...
Hi All

I am dealing a project in ASP.NET in which I have to establish a connection to SQL Server 2000 database,where the database was located on a remote
system.
For this I have used SQLConnection object and specified the connetion
string.But when it comes to establish a connection its giving me the Error
that

I. Connection string : workstation id=localhost;packet size=4096;user
id=sa;data source=192.168.0.106;persist security info=False;initial
catalog=db

Error : System.Data.SqlClient.SqlException: Login failed for user 'sa'.
Reason: Not associated with a trusted SQL Server connection.

then I have inserted one new attribute 'Network = dbmssocn' and modified the connection string as below

II. Connection string : workstation id=localhost;packet size=4096;user
id=sa;data source=192.168.0.106;Network=DBMSSOCN;persist security
info=False; initial catalog=db

then I got the below Error when try to establish a connection.

Error : System.Data.SqlClient.SqlException: SQL Server does not exist or access denied

Note:

1. Here the client machine has VS.NET and IIS installed on it and the SQL
Server 2000 is running on a remote machine but both are in the same
"Workgroup network".

2.The authentication mode of the SQL Server 2000 is Mixed Authentivation(SQL Server and Windows)

3.Firewall is also enabled on the remote machine where the SQL Server 2000
is ruuning,

4.Both Client and Server running on Windows Xp OS with SP2 installed.

Hence,I am requesting you people to help in specifying the correct
connection string(I mean where I have done the mistake)so that I can
establish a connection.

5.One more issue is that its working fine when as desktop application(i.e, I am able to extablish connection from a desktop application done in
VB.NET,but wasn't working in web application.)Please let me know my
mistake...........as I have gone through so many forums and didn't find
solution for this.

Thanks in advance
Vighneswar

Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- ...
10
by: Brian Conway | last post by:
I have no idea what is going on. I have a Login screen where someone types in their login information and this populates a datagrid based off of the login. Works great in debug and test through...
1
by: William Urban | last post by:
Hello all, first time posting here and I am running into a pickle of a problem. Here is the scenario. I have a Windows 2000 server running IIS and an ASP.net C# application. The application...
15
by: DavidS | last post by:
Have Visual Studio.NET installed on MS 2000 Professional OS laptop. No issue ever with web development and SQL connections. Purchased new laptop with XP Professional SP2!!!!!!!! & Visual...
16
by: peshekeedweller | last post by:
Using asp.net 1.1. vb.net 2003. I am trying to connect to a remote sql server 2000 on a virtual machine running windows 2000 server. I can connect through the server explorer in visual studio,...
1
by: Carlos | last post by:
Hi all, I have a ASP.NET app that uses SQL Server 2000 to access the data over the internet and everything works fine . However, I just installed SQL server 2005, and wanted to test the remote...
1
by: A Hirsi | last post by:
I have created a vb .net program as a service that is using a simple ftpclient to connect to a remote server and check the status of a file for subsequent downloading if there have been changes to...
1
by: Brad Isaacs | last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am working with Login controls ASP.Configuration, I...
4
by: Brad Isaacs | last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am working with Login controls ASP.Configuration, I...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.