| 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.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
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 |
|
|
|
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.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
|
|
|
|
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
|
|
|
|
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. |
|
|
|
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 |
|
|
|
abacusdotcom
Posting Yak Master
133 Posts |
Posted - 2005-06-30 : 05:06:59
|
Hi Merkinquote:
Originally posted by Merkin
What OS is the SQL Server running on ?
Window xp sp 2 operating systemquote:
Is it on the same network subnet ? Is it firewalled ?
Yes on the same network subnet and none of the systems is firewalledThanksAbacusI sign for fame not for shame but all the same, I sign my name. |
|
|
|
abacusdotcom
Posting Yak Master
133 Posts |
Posted - 2005-06-30 : 05:07:05
|
Hi Merkinquote:
Originally posted by Merkin
What OS is the SQL Server running on ?
Window xp sp 2 operating systemquote:
Is it on the same network subnet ? Is it firewalled ?
Yes on the same network subnet and none of the systems is firewalledThanksAbacusI sign for fame not for shame but all the same, I sign my name. |
|
|
|
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
|
|
|
|
|
SQL Server does not exist or access denied