473,327 Members | 2,025 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,327 software developers and data experts.

dotnet - 2003 server. Urget. Please!

Jay
Quick scenario followed by details below
ASP.NET application and MSDE installed on our Win2k dev server. All is good
Replicated this on our Win2.3k production server... problem!

Error is 'server does not exist or access is denied

Details
I installed MSDE via oSQL: setup sapwd=xxx securitymode=sq
Then I installed SQL server client tools only
Restored the DB to the new instance from a .bak file

Created the login, gave it access to the required db and made it dbo
Set up IIS for the dot net app and did all the necessaries IIS and NTFS wise... treble checked

The dotnet app has a connection string that passes the db username and pwd. (checked by running query analyser and connecting). The app error log gives the above error

What can be wrong? The IIS/SQL/app is all the same server. have tried (local) and 127.0.0.1 for datasource
SQL is running. IIS is fine. NTFS is correct. SQL account has full permissions on sql. ASPNET and IUSR_machinename given full control for testing
Ran SQL profiler and there isn't even a log on attempt by the user/app
Any one shed any light? Any more details needed then feel free to yell out
Supposed to be launching this tomorrow and am stumped for any more debugging options

Ja

Jul 21 '05 #1
8 1536
Jay
Knocked up the simplest of ASPX pages to whittle down the complexity..
Text box passes the connection string and a second text box is populated with either "connected" or the error message
Always the same.... server does not exist or access denied :(
Jul 21 '05 #2
Jay
Knocked up the simplest of ASPX pages to whittle down the complexity..
Text box passes the connection string and a second text box is populated with either "connected" or the error message
Always the same.... server does not exist or access denied :(
Jul 21 '05 #3
Jay,

Look in [SQL Server Install Path]\80\Tools\Binn for the svrnetcn.exe app.
Run it and make sure named pipes and TCP/IP is enabled for both servers.

-Brian

"Jay" <an*******@discussions.microsoft.com> wrote in message
news:A5**********************************@microsof t.com...
Knocked up the simplest of ASPX pages to whittle down the complexity...
Text box passes the connection string and a second text box is populated with either "connected" or the error message. Always the same.... server does not exist or access denied :(

Jul 21 '05 #4
Jay,

Look in [SQL Server Install Path]\80\Tools\Binn for the svrnetcn.exe app.
Run it and make sure named pipes and TCP/IP is enabled for both servers.

-Brian

"Jay" <an*******@discussions.microsoft.com> wrote in message
news:A5**********************************@microsof t.com...
Knocked up the simplest of ASPX pages to whittle down the complexity...
Text box passes the connection string and a second text box is populated with either "connected" or the error message. Always the same.... server does not exist or access denied :(

Jul 21 '05 #5
Jay
Already confirmed.
Jul 21 '05 #6
Jay
Already confirmed.
Jul 21 '05 #7
Jay
Solved
When I installed MSDE..... >setup sapwd=xxx etc et
The instance inherited the name of the machine it was installed on
I changed the connection string in my web.config file to point to the instance name as opposed to (local) or 127.0.0.
All is well with the world again

Jay
Jul 21 '05 #8
Jay
Solved
When I installed MSDE..... >setup sapwd=xxx etc et
The instance inherited the name of the machine it was installed on
I changed the connection string in my web.config file to point to the instance name as opposed to (local) or 127.0.0.
All is well with the world again

Jay
Jul 21 '05 #9

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

Similar topics

5
by: Art Vandelay | last post by:
I have bought VS dotnet 2002, and then VS 2003. Now I need 2004 ASAP. Please go ahead and charge me and get me VS 2005 ASAP as well. You see, if I'm not able to consistently and frequently change...
1
by: DCraig | last post by:
I'm having problems printing to a line printer from both Crystal Reports and SQL Server reporting services using dotnet. When I try and print a report from an application with Crystal I get the...
7
by: tuanhoanganh | last post by:
I have a problem with my application. When I run it \\server\program\login.exe it work well but when I map \\server\program to Z: and run Z:\login.exe it doesn't work. Please help me. Thank you....
4
by: Peter Hemmingsen | last post by:
Hi, I have a dotnet object (implemented in mc++ and used in c#) which have a property called "Info". The Info property is also a dotnet object (implemented in mc++). In the constructor of the...
22
by: EP | last post by:
When running my asp.net hosting service (asp.net without IIS), on server 2003 with IIS not installed, I get the following when trying to process a request. "System.DllNotFoundException: Unable to...
8
by: Jay | last post by:
Quick scenario followed by details below ASP.NET application and MSDE installed on our Win2k dev server. All is good Replicated this on our Win2.3k production server... problem! Error is 'server...
0
by: apondu | last post by:
hi, I am new to Sharepoint Server. I was just trying to install sharepoint server and work with it. I wanted to access the sharepoint server services with dotnet and work with it. I just...
0
by: satish | last post by:
Jagadeesh satish@globalinfotechinc.com 217-241-2015 SUMMARY * Over Six years of experience in analysis, design, development, testing and maintenance of object-oriented programming and software...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.