Asp.net Forum

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds

Moving my C# project from XP to another computer running Windows 20

  Asked By: Kuhaylah    Date: Mar 15    Category: Asp.net    Views: 1405

I'm have a whole project finished, running
perfectly happily in Windows XP. It uses a SQL connection to another
computer running SQL 7.0. Everything is written in C#. However, the
final computer this project is to run on is running Windows Advanced
Server 2000. I have moved the files to an intermediate machine, and
now I get an SQL connection error saying that

"The SQL server does not exist or access denied"

I thought maybe the problem was the part of the connection string that
said "workstation id=RALPH" (RALPH is the development machine, APU is
the one I'm trying to host it on), so I changed it to "workstation
id=APU", then just deleted it altogether. I copied the whole
directory over, so the assembly in the \bin directory is also there.
If anybody can tell me what to do to fix this, please help me.



9 Answers Found

Answer #1    Answered By: Pravat Jainukul     Answered On: Mar 15

If you're using Integrated SQL Security, you need to setup the 2000AS box
for asp.net impersonation using an account which has SQL access.

Answer #2    Answered By: Rocco Anderson     Answered On: Mar 15

Okay. Can you tell me how to do that? And thanks for the quick
response... I'm impressed.

I'm using a SQL username and password, I assumed that as long as I
was using the same username, the project  would work hosted on any
computer... is this not the case?

Answer #3    Answered By: Scott Simmons     Answered On: Mar 15

It should be working fine then. Presumably you can ping the SQL Server from
the 2000 server, and the login is valid.

Answer #4    Answered By: Raju Srinivas     Answered On: Mar 15

My connection  string at the moment looks like this:

this.sqlConnection1.ConnectionString = "data source=HOMER;initial
catalog=Change_Control;password=starwars;persist security
info=True;user id=myprojectname;packet size=4096";

Answer #5    Answered By: Neil Turner     Answered On: Mar 15

Firstly, I wouldn't recommend that you post your password in the future. :)

Try dumbing the con string down to something like this for troubleshooting:

data source=HOMER;initial catalog=ChangeControl;user

Answer #6    Answered By: Katrina Edwards     Answered On: Mar 15

By the way, I'm using Visual Studio .NET, and that's the string it
generated for me, minus the "workstation id=" part. I'll try
dumbing it down and get back to you.

Answer #7    Answered By: Eddie Austin     Answered On: Mar 15

Okay, I dumbed it down, and still got the same error. You think
this might be a SQL server configuration issue? I don't know much
about how SQL server works. (By the way, yes, I can ping from APU to

Answer #8    Answered By: Antonio Dunn     Answered On: Mar 15

Have you tried installing EM on the 2000AS and checking to see if you can
login with your credentials?

Answer #9    Answered By: Holly Brown     Answered On: Mar 15

I just found the guy in charge of the SQL test server I
was trying to connect to, and it turns out that it's DNS wasn't set
up correctly. Anyway, I changed "HOMER" to the IP address, and now
everything works fine. Thanks for all your help, I'll definately be
using this forum from now on.