473,241 Members | 1,875 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,241 software developers and data experts.

Sql Server does not exist or access denied issue again

I know this has come up frequently but I can't seem to put my finger on
the precise problem as it applies to me. I have a workgroup with a 2003
box with Sql server on it. Also, on this, I have an XP pro machine. So
the xp pro machine is running IIS. When I try and open a connection to
the Sql Server I get the Sql Server does not exist etc.

I am wondering what I need to do to correct this exactly. Because it is
on a workgroup and not a domain how do I solve the problem. Do I need
to have an id on the xp machine that is the same as one of the server,
I tried this but it doesn't seem to work for me.

There is plenty of info out there for domains but not workgroups. Any
ideas??

Thanks

Eamonn

Jul 23 '05 #1
7 2538

"Jenbo" <ej***@allstate.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I know this has come up frequently but I can't seem to put my finger on
the precise problem as it applies to me. I have a workgroup with a 2003
box with Sql server on it. Also, on this, I have an XP pro machine. So
the xp pro machine is running IIS. When I try and open a connection to
the Sql Server I get the Sql Server does not exist etc.

I am wondering what I need to do to correct this exactly. Because it is
on a workgroup and not a domain how do I solve the problem. Do I need
to have an id on the xp machine that is the same as one of the server,
I tried this but it doesn't seem to work for me.

There is plenty of info out there for domains but not workgroups. Any
ideas??

Thanks

Eamonn


http://support.microsoft.com/default...b;en-us;328306

If this doesn't help, then you should post some more information - which
version and edition of MSSQL do you have, which authentication mode are you
using, how are you testing the connection etc.

Simon
Jul 23 '05 #2
I have looked at this article a lot and it does not have any specific
info on workgroups, just domains. I am using SQL Server Enterprise I
think, authenication is mixed mode. The problem seems to be that the
user of the client machine cannot access the SQL server. Do I need to
do something like create a user on the client called test with pwd and
then create the same user on the server machine, and create this in SQL
Server???

This is a workgroup I am dealing with not a domain so I am wondering if
this would work.

Simon Hayes wrote:
"Jenbo" <ej***@allstate.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I know this has come up frequently but I can't seem to put my finger on the precise problem as it applies to me. I have a workgroup with a 2003 box with Sql server on it. Also, on this, I have an XP pro machine. So the xp pro machine is running IIS. When I try and open a connection to the Sql Server I get the Sql Server does not exist etc.

I am wondering what I need to do to correct this exactly. Because it is on a workgroup and not a domain how do I solve the problem. Do I need to have an id on the xp machine that is the same as one of the server, I tried this but it doesn't seem to work for me.

There is plenty of info out there for domains but not workgroups. Any ideas??

Thanks

Eamonn

http://support.microsoft.com/default...b;en-us;328306

If this doesn't help, then you should post some more information -

which version and edition of MSSQL do you have, which authentication mode are you using, how are you testing the connection etc.

Simon


Jul 23 '05 #3
Try adding the hostname(xp machine) to the LMHost file on win2003. And
then try adding it to sql client configuration.

It worked for me.

Jul 23 '05 #4

"Jenbo" <ej***@allstate.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
I have looked at this article a lot and it does not have any specific
info on workgroups, just domains. I am using SQL Server Enterprise I
think, authenication is mixed mode. The problem seems to be that the
user of the client machine cannot access the SQL server. Do I need to
do something like create a user on the client called test with pwd and
then create the same user on the server machine, and create this in SQL
Server???

This is a workgroup I am dealing with not a domain so I am wondering if
this would work.


<snip>

If you're using mixed mode, then the first thing to try would be connecting
with a SQL login which you know works fine when you're logged on to the
server:

osql -S MyServer -U sa -P xxxx

If that doesn't work, then you probably have some basic connectivity issue,
so you could look at name resolution, protocol configuration and so on. If
it does work, but a trusted connection doesn't, then you probably have an
issue related to workgroup security. As far as I know, if you have local
user accounts on the client and server with the same name and same password,
then you should be able to connect to the server. However, it's possible
that Server 2003 is setup somehow to disallow such connections by default -
you can test with something basic like connecting to a share on the server.
If that doesn't work, then you'll have to investigate workgroup security,
which is probably something to take up in a Windows security group.

Personally, I would consider setting up a domain - if you have the resources
to implement Enterprise Edition on Server 2003, then presumably you have the
resources to operate a domain, although of course I don't know your
situation, so you may well have a good reason for going with a workgroup.

Simon

Jul 23 '05 #5
I was having this exact same problem yesterday and foud out the fix
just 30 minutes ago. I am also operating in a Workgroup and like you
could not find any solutions. I hope this helps...

On the server running MSSQLServer,
Open the network connection properties for you NIC.
Be sure you only have the following installed:
Client for MS Networks
File and Printer Sharing
TCP/IP

I originally had these additional components installed:
AppleTalk
Client Network Monitor

I removed both from Add/Remove Windows Components and network
connections at the same time, so not sure which one caused the
conflict.

Good Luck

Jul 23 '05 #6
I have a related question: when i installed sql server, i chose windows
auth. instead of mixed mode. Although a second pc can see a sql
instance from the first pc, i cannot log-in using a sql login. How do i
change to mixed mode?

Jul 23 '05 #7
chrispycrunch (ch***********@gmail.com) writes:
I have a related question: when i installed sql server, i chose windows
auth. instead of mixed mode. Although a second pc can see a sql
instance from the first pc, i cannot log-in using a sql login. How do i
change to mixed mode?


You do this from Enterprise Manager. If memory servers, you right-
click the server, choose properites, and then go the Security tab.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #8

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

Similar topics

2
by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an...
2
by: Chris Stewart | last post by:
We're having an issue here at school with trying to access a SQL Server database from a .NET application. As a department, we roll out a generic image to all of our lab computers. For some reason...
2
by: mal hit | last post by:
We developed an ASP.NET application on Windows 2000/SQL Server 2000/IIS 5.0. Recently, we moved the SQL Server 2000 database to Windows 2003. Now, we are unable to connect to the database (on...
3
by: Hermit Dave | last post by:
Hi, I am getting this SQLException: Sql Server does not exist or access denied Here is the situation: Build machine: VS 2003, Framework 1.1, Windows XP and SQL Server I have two sets of...
9
by: Steven Ung | last post by:
Hello all, I'm having the following error dump from an ASP.net application. The program is to calculate MRP and it involves complex queries looping thru hundreds of records in an few SQL 2000...
1
by: Atia Amin | last post by:
Hi, I am a new member. Hello to every one. I am new in ASP.NET area. I wrote an ASP.NET web application which was running ok with my old laptop. Currently I have given a new laptop. Now I copied...
1
by: vamshika | last post by:
hi, I got a serious Problem. I get "Server does not exist or access denied" with 80004005 as the error code. the win2003 server uses all the latest components(like iis6,jet..etc) and is upto date....
3
by: scarecrowwu | last post by:
I'm a newer in .net. I cann't conect to the SQLServer on a local area network computer.The more strange thing is that I can connect to another SQLServer which in USA.Now I'm in China. My...
1
by: ahmnasa | last post by:
I have a website that has been running for over 1 year now that has never had these issues. Its running MS SQL Server 2005 Express Edition and IIS6 ASP 3 coded. All running from one server. I...
2
by: jayman9782 | last post by:
Hey all, I'm having a common problem under different circumstances. A little background information: I am running an "in-house" ASP web application in .NET 1.1 with a back-end in SQL Server 2000....
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...
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...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
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"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...

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.