Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 SQL Server does not exist or access denied

Author  Topic 

lethalpower
Starting Member

4 Posts

Posted - 2005-06-28 : 16:47:23
I have researched previous posts about the subject but my situation is a little different. I can access and conect to the server and run a windows VB.Net simple app with no problem but if i try do run an ASP.net web app I get the "SQL Server does not exist or access denied" Error. I can even preview the data by right clicking on the data adapter and selecting "Preview Data...". I can also click the "Fill Dataset" button and see the records in the table. I have try several solutions like recycling the app pool,and adding attributes to the connection string, nothing works. How come I can conect from one app and not the other if I'm using the same con string? Please help :#(

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-06-28 : 22:49:11
Can you post the connection string (change IP addresses if you are using them, which you shouln't be). Also, don't post the actual password if you are using a SQL Server user.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-29 : 02:36:59
Would you happen to be using XP SP2 and an instance of SQL Server that isn't patched to SP3 on your workstation ?



Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

lethalpower
Starting Member

4 Posts

Posted - 2005-06-29 : 09:04:30
The conection string is:
"workstation id=MARJIEOCASIO;packet size=4096;user id=ReadOnly;data source=SERVER;persist security info=False;initial catalog=Calibration2001SQL"

quote:
Originally posted by derrickleggett

Can you post the connection string (change IP addresses if you are using them, which you shouln't be). Also, don't post the actual password if you are using a SQL Server user.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Go to Top of Page

lethalpower
Starting Member

4 Posts

Posted - 2005-06-29 : 09:36:45
Yes I'm using XP SP2 but I'm not sure about SQL Server. I don't SQL Server on my machine and all I know is that the server has SQL server 8 on it. Let's pretend that it is not patched. What should I do??
quote:
Originally posted by Merkin

Would you happen to be using XP SP2 and an instance of SQL Server that isn't patched to SP3 on your workstation ?



Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

Go to Top of Page

abacusdotcom
Posting Yak Master

133 Posts

Posted - 2005-06-29 : 12:01:46
Hi all,
I have the same problem here too. I am runing the sql server on a development server (sql server 2000 without sp 3 am sure on win xp sp 2) and connecting to the server from another work station (executing the asp.net pages). Is sp 3 the problem? what should i do?

I sign for fame not for shame but all the same, I sign my name.
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-29 : 19:58:25
What OS is the SQL Server running on ?
Is it on the same network subnet ? Is it firewalled ?


Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

abacusdotcom
Posting Yak Master

133 Posts

Posted - 2005-06-30 : 05:06:59
Hi Merkin

quote:
Originally posted by Merkin

What OS is the SQL Server running on ?


Window xp sp 2 operating system
quote:


Is it on the same network subnet ? Is it firewalled ?


Yes on the same network subnet and none of the systems is firewalled

Thanks
Abacus



I sign for fame not for shame but all the same, I sign my name.
Go to Top of Page

abacusdotcom
Posting Yak Master

133 Posts

Posted - 2005-06-30 : 05:07:05
Hi Merkin

quote:
Originally posted by Merkin

What OS is the SQL Server running on ?


Window xp sp 2 operating system
quote:


Is it on the same network subnet ? Is it firewalled ?


Yes on the same network subnet and none of the systems is firewalled

Thanks
Abacus



I sign for fame not for shame but all the same, I sign my name.
Go to Top of Page

lethalpower
Starting Member

4 Posts

Posted - 2005-06-30 : 09:12:23
Hi Merkin,
Win XP SP2, same subnet, no firewall.
BTW the suspence is killing me...
Throw me a bone.

quote:
Originally posted by Merkin

What OS is the SQL Server running on ?
Is it on the same network subnet ? Is it firewalled ?


Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

Go to Top of Page
   

- Advertisement -