Getting a permission denied - but not using that user?

In my database I created a SQL Server user - malphaTest
In my WebConfig.xml
<add key="SQLConn"
value="Data Source=HIDSCFILE002;Initial Catalog=Membership;User
ID=malphaTest;Password=12345;Trusted_Con
nection=False"/>
</appSettings>
The error returned when press the search button to query the database is:
EXECUTE permission denied on object 'qMemberSelect', database 'Membership',
owner 'dbo'
Shouldn't it refer to malphaTest? not dbo?No, the owner of the object that you aquired is dbo. So you have to
grant the user malphaTest EXECUTE rights on the procedure
/dbo.'qMemberSelect') to get around this error.
HTH, Jens Suessmeyer.

Getting a permission denied - but not using that user?

In my database I created a SQL Server user - malphaTest
In my WebConfig.xml
<add key="SQLConn"
value="Data Source=HIDSCFILE002;Initial Catalog=Membership;User
ID=malphaTest;Password=12345;Trusted_Connection=Fa lse"/>
</appSettings>
The error returned when press the search button to query the database is:
EXECUTE permission denied on object 'qMemberSelect', database 'Membership',
owner 'dbo'
Shouldn't it refer to malphaTest? not dbo?
No, the owner of the object that you aquired is dbo. So you have to
grant the user malphaTest EXECUTE rights on the procedure
/dbo.'qMemberSelect') to get around this error.
HTH, Jens Suessmeyer.
sql

Getting 401 Access denied w/ Endpoint in SQL 2005 from C# client

I have a Windows Forms application in C# (VS.NET 2005) that accesses SQL 2005
web services using integrated authentication.
In development (Windows XP Pro, SQL 2005 Dev) the SQL servers are on the
same workstations as the client and connectivity works fine.
In testing, the windows app is begin deployed to a Windows 2000 Server
workstation and SQL Server 2005 is installed on a Windows 2003 Server. Both
are on the same domain. The user logged into the client station has admin
access on the server and dbo access (and in this case created the endpoints).
However, when the client attempts to access the server, 401 Access Denied is
returned.
The server specifies Integrated Authentication as follows:
CREATE ENDPOINT RMS
STATE = STARTED
AS HTTP (
SITE = 'SERVER',
PATH = '/sql/app1',
AUTHENTICATION = (INTEGRATED),
PORTS=(CLEAR)
)
The client adds the credentials to the cache before the call:
ws.Credentials =
System.Net.CredentialCache.DefaultCredentials;
I think I've covered everything here and from what I have read, the error
indicates that the user is not being authenticated (vs an issue with any
specific SQL object permissions).
Any ideas on what might be happening here and how to fix?
Thanks
-Luther
Hi Luther,
welcome to MSDN newsgroup.
As for the SQL2005's endpoint SOAP webservice, after you created the
endpoint, have you tried using IE browser to view the WSDL document of that
endpoint service? e.g:
http://servername/sql/test_endpoint?WSDL
If this also not work, the problem is likely due to the serverside
setting... If that works, we may need to check the client side code...
Also, you can print out the thread's current secuirty principal to see
whether it is the correct domain account of the server machine ...
In addition , you can also try adding the "Authorizing" setting to grant
certain user/role the permission as below:
AUTHORIZATION sa -- with optional authorization for owner
=======================
CREATE ENDPOINT zipcodes -- create the Http Endpoint
AUTHORIZATION sa -- with optional authorization for owner
STATE = STARTED -- the state of the endpoint
AS HTTP ( -- can be http, tcp, ...
path='/sql/zipcodes', -- the virtual path
AUTHENTICATION=(INTEGRATED), -- type of authentication
PORTS=(CLEAR), -- which ports (clear=all)
SITE ='*' -- site can be '*" or 'myserver'
)
FOR SOAP( -- type of protocol, in this case, SOAP for a webservice
WEBMETHOD 'http://tempuri.org/'.'DistanceBetweenzZipCodes'
-- define the webmethod(s) and fully qualified sproc
(name='zipcodes.dbo.DistanceBetweenZipcodes',
SCHEMA = STANDARD ),
======================
If there're any other findings, please feel free to post here.
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| Thread-Topic: Getting 401 Access denied w/ Endpoint in SQL 2005 from C#
client
| thread-index: AcYMnwmiqttQJ9quQhelBHxCetS8Eg==
| X-WBNR-Posting-Host: 63.211.139.67
| From: "=?Utf-8?B?THV0aGVyIE1pbGxlcg==?=" <lex3001@.community.nospam>
| Subject: Getting 401 Access denied w/ Endpoint in SQL 2005 from C# client
| Date: Thu, 29 Dec 2005 09:41:02 -0800
| Lines: 39
| Message-ID: <910F2F43-FF93-4110-A162-2C04A46F4451@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.connect
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.connect:46496
| X-Tomcat-NG: microsoft.public.sqlserver.connect
|
| I have a Windows Forms application in C# (VS.NET 2005) that accesses SQL
2005
| web services using integrated authentication.
|
| In development (Windows XP Pro, SQL 2005 Dev) the SQL servers are on the
| same workstations as the client and connectivity works fine.
|
| In testing, the windows app is begin deployed to a Windows 2000 Server
| workstation and SQL Server 2005 is installed on a Windows 2003 Server.
Both
| are on the same domain. The user logged into the client station has admin
| access on the server and dbo access (and in this case created the
endpoints).
|
| However, when the client attempts to access the server, 401 Access Denied
is
| returned.
|
| The server specifies Integrated Authentication as follows:
|
| CREATE ENDPOINT RMS
| STATE = STARTED
| AS HTTP (
| SITE = 'SERVER',
| PATH = '/sql/app1',
| AUTHENTICATION = (INTEGRATED),
| PORTS=(CLEAR)
| )
|
| The client adds the credentials to the cache before the call:
|
| ws.Credentials =
| System.Net.CredentialCache.DefaultCredentials;
|
| I think I've covered everything here and from what I have read, the error
| indicates that the user is not being authenticated (vs an issue with any
| specific SQL object permissions).
|
| Any ideas on what might be happening here and how to fix?
|
| Thanks
| -Luther
|
|

Getting 401 Access denied w/ Endpoint in SQL 2005 from C# client

I have a Windows Forms application in C# (VS.NET 2005) that accesses SQL 200
5
web services using integrated authentication.
In development (Windows XP Pro, SQL 2005 Dev) the SQL servers are on the
same workstations as the client and connectivity works fine.
In testing, the windows app is begin deployed to a Windows 2000 Server
workstation and SQL Server 2005 is installed on a Windows 2003 Server. Both
are on the same domain. The user logged into the client station has admin
access on the server and dbo access (and in this case created the endpoints)
.
However, when the client attempts to access the server, 401 Access Denied is
returned.
The server specifies Integrated Authentication as follows:
CREATE ENDPOINT RMS
STATE = STARTED
AS HTTP (
SITE = 'SERVER',
PATH = '/sql/app1',
AUTHENTICATION = (INTEGRATED),
PORTS=(CLEAR)
)
The client adds the credentials to the cache before the call:
ws.Credentials =
System.Net.CredentialCache.DefaultCredentials;
I think I've covered everything here and from what I have read, the error
indicates that the user is not being authenticated (vs an issue with any
specific SQL object permissions).
Any ideas on what might be happening here and how to fix?
Thanks
-LutherHi Luther,
welcome to MSDN newsgroup.
As for the SQL2005's endpoint SOAP webservice, after you created the
endpoint, have you tried using IE browser to view the WSDL document of that
endpoint service? e.g:
http://servername/sql/test_endpoint?WSDL
If this also not work, the problem is likely due to the serverside
setting... If that works, we may need to check the client side code...
Also, you can print out the thread's current secuirty principal to see
whether it is the correct domain account of the server machine ...
In addition , you can also try adding the "Authorizing" setting to grant
certain user/role the permission as below:
AUTHORIZATION sa -- with optional authorization for owner
=======================
CREATE ENDPOINT zipcodes -- create the Http Endpoint
AUTHORIZATION sa -- with optional authorization for owner
STATE = STARTED -- the state of the endpoint
AS HTTP ( -- can be http, tcp, ...
path='/sql/zipcodes', -- the virtual path
AUTHENTICATION=(INTEGRATED), -- type of authentication
PORTS=(CLEAR), -- which ports (clear=all)
SITE ='*' -- site can be '*" or 'myserver'
)
FOR SOAP( -- type of protocol, in this case, SOAP for a webservice
WEBMETHOD 'http://tempuri.org/'.'DistanceBetweenzZipCodes'
-- define the webmethod(s) and fully qualified sproc
(name='zipcodes.dbo.DistanceBetweenZipcodes',
SCHEMA = STANDARD ),
======================
If there're any other findings, please feel free to post here.
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| Thread-Topic: Getting 401 Access denied w/ Endpoint in SQL 2005 from C#
client
| thread-index: AcYMnwmiqttQJ9quQhelBHxCetS8Eg==
| X-WBNR-Posting-Host: 63.211.139.67
| From: "examnotes" <lex3001@.community.nospam>
| Subject: Getting 401 Access denied w/ Endpoint in SQL 2005 from C# client
| Date: Thu, 29 Dec 2005 09:41:02 -0800
| Lines: 39
| Message-ID: <910F2F43-FF93-4110-A162-2C04A46F4451@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.connect
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.connect:46496
| X-Tomcat-NG: microsoft.public.sqlserver.connect
|
| I have a Windows Forms application in C# (VS.NET 2005) that accesses SQL
2005
| web services using integrated authentication.
|
| In development (Windows XP Pro, SQL 2005 Dev) the SQL servers are on the
| same workstations as the client and connectivity works fine.
|
| In testing, the windows app is begin deployed to a Windows 2000 Server
| workstation and SQL Server 2005 is installed on a Windows 2003 Server.
Both
| are on the same domain. The user logged into the client station has admin
| access on the server and dbo access (and in this case created the
endpoints).
|
| However, when the client attempts to access the server, 401 Access Denied
is
| returned.
|
| The server specifies Integrated Authentication as follows:
|
| CREATE ENDPOINT RMS
| STATE = STARTED
| AS HTTP (
| SITE = 'SERVER',
| PATH = '/sql/app1',
| AUTHENTICATION = (INTEGRATED),
| PORTS=(CLEAR)
| )
|
| The client adds the credentials to the cache before the call:
|
| ws.Credentials =
| System.Net.CredentialCache.DefaultCredentials;
|
| I think I've covered everything here and from what I have read, the error
| indicates that the user is not being authenticated (vs an issue with any
| specific SQL object permissions).
|
| Any ideas on what might be happening here and how to fix?
|
| Thanks
| -Luther
|
|

Getting "SQL Server does not exist or access denied" error messages

For some reason, this week we started to get "SQL Server does not exist or
access denied" error messages when attempting to connect to our SQL Server
databases. This only affects people who dial into our network. But this
seems to be a rather complicated situation, so let me explain.
We have a couple of VB6 applications we've written. People log into our
network and get authenticated on our network (username, password and domain
must be specified). We have a test server with SQL Server 2000 installed.
The test server is a Windows 2000 Server. The production server has SQL
Server 2000 installed also, but it is a Windows 2003 Server. I have found,
for example, that I can define an ODBC DSN to the test database and retrieve
data just fine, but I can NOT do the same thing to the production database
on the production server. However, our users were able to do so up until
Tuesday of this week. The only thing I can think of which has changed is I
applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
the DHCP server. But the DHCP server is not either the production or test
database servers, so I have no idea why that should make any difference at
all.
Does anyone have any idea why this problem is now showing up?
Rod
Hi Rod,
If this is was fine before, then I would suspect that it is an issue related
to the security. Usually this error happens when client does not have
permissions to connect to the SQL Server. Could be that last changes in a
fixes were related to the security issues. Do you know which patches were
installed exactly. If yes, then you could check KB articles for them to see
if installation of them does not change any security settings.
Val Mazur
Microsoft MVP
"Rod" <Rod@.NO.SPAM> wrote in message
news:u05d8jpaEHA.4092@.TK2MSFTNGP11.phx.gbl...
> For some reason, this week we started to get "SQL Server does not exist or
> access denied" error messages when attempting to connect to our SQL Server
> databases. This only affects people who dial into our network. But this
> seems to be a rather complicated situation, so let me explain.
> We have a couple of VB6 applications we've written. People log into our
> network and get authenticated on our network (username, password and
> domain
> must be specified). We have a test server with SQL Server 2000 installed.
> The test server is a Windows 2000 Server. The production server has SQL
> Server 2000 installed also, but it is a Windows 2003 Server. I have found,
> for example, that I can define an ODBC DSN to the test database and
> retrieve
> data just fine, but I can NOT do the same thing to the production database
> on the production server. However, our users were able to do so up until
> Tuesday of this week. The only thing I can think of which has changed is I
> applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
> the DHCP server. But the DHCP server is not either the production or test
> database servers, so I have no idea why that should make any difference at
> all.
> Does anyone have any idea why this problem is now showing up?
> Rod
>
>

Getting "SQL Server does not exist or access denied" error messages

For some reason, this week we started to get "SQL Server does not exist or
access denied" error messages when attempting to connect to our SQL Server
databases. This only affects people who dial into our network. But this
seems to be a rather complicated situation, so let me explain.
We have a couple of VB6 applications we've written. People log into our
network and get authenticated on our network (username, password and domain
must be specified). We have a test server with SQL Server 2000 installed.
The test server is a Windows 2000 Server. The production server has SQL
Server 2000 installed also, but it is a Windows 2003 Server. I have found,
for example, that I can define an ODBC DSN to the test database and retrieve
data just fine, but I can NOT do the same thing to the production database
on the production server. However, our users were able to do so up until
Tuesday of this week. The only thing I can think of which has changed is I
applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
the DHCP server. But the DHCP server is not either the production or test
database servers, so I have no idea why that should make any difference at
all.
Does anyone have any idea why this problem is now showing up?
RodHi Rod,
If this is was fine before, then I would suspect that it is an issue related
to the security. Usually this error happens when client does not have
permissions to connect to the SQL Server. Could be that last changes in a
fixes were related to the security issues. Do you know which patches were
installed exactly. If yes, then you could check KB articles for them to see
if installation of them does not change any security settings.
Val Mazur
Microsoft MVP
"Rod" <Rod@.NO.SPAM> wrote in message
news:u05d8jpaEHA.4092@.TK2MSFTNGP11.phx.gbl...
> For some reason, this week we started to get "SQL Server does not exist or
> access denied" error messages when attempting to connect to our SQL Server
> databases. This only affects people who dial into our network. But this
> seems to be a rather complicated situation, so let me explain.
> We have a couple of VB6 applications we've written. People log into our
> network and get authenticated on our network (username, password and
> domain
> must be specified). We have a test server with SQL Server 2000 installed.
> The test server is a Windows 2000 Server. The production server has SQL
> Server 2000 installed also, but it is a Windows 2003 Server. I have found,
> for example, that I can define an ODBC DSN to the test database and
> retrieve
> data just fine, but I can NOT do the same thing to the production database
> on the production server. However, our users were able to do so up until
> Tuesday of this week. The only thing I can think of which has changed is I
> applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
> the DHCP server. But the DHCP server is not either the production or test
> database servers, so I have no idea why that should make any difference at
> all.
> Does anyone have any idea why this problem is now showing up?
> Rod
>
>

Getting "SQL Server does not exist or access denied" error messages

For some reason, this week we started to get "SQL Server does not exist or
access denied" error messages when attempting to connect to our SQL Server
databases. This only affects people who dial into our network. But this
seems to be a rather complicated situation, so let me explain.
We have a couple of VB6 applications we've written. People log into our
network and get authenticated on our network (username, password and domain
must be specified). We have a test server with SQL Server 2000 installed.
The test server is a Windows 2000 Server. The production server has SQL
Server 2000 installed also, but it is a Windows 2003 Server. I have found,
for example, that I can define an ODBC DSN to the test database and retrieve
data just fine, but I can NOT do the same thing to the production database
on the production server. However, our users were able to do so up until
Tuesday of this week. The only thing I can think of which has changed is I
applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
the DHCP server. But the DHCP server is not either the production or test
database servers, so I have no idea why that should make any difference at
all.
Does anyone have any idea why this problem is now showing up?
Rod
Hi Rod,
If this is was fine before, then I would suspect that it is an issue related
to the security. Usually this error happens when client does not have
permissions to connect to the SQL Server. Could be that last changes in a
fixes were related to the security issues. Do you know which patches were
installed exactly. If yes, then you could check KB articles for them to see
if installation of them does not change any security settings.
Val Mazur
Microsoft MVP
"Rod" <Rod@.NO.SPAM> wrote in message
news:u05d8jpaEHA.4092@.TK2MSFTNGP11.phx.gbl...
> For some reason, this week we started to get "SQL Server does not exist or
> access denied" error messages when attempting to connect to our SQL Server
> databases. This only affects people who dial into our network. But this
> seems to be a rather complicated situation, so let me explain.
> We have a couple of VB6 applications we've written. People log into our
> network and get authenticated on our network (username, password and
> domain
> must be specified). We have a test server with SQL Server 2000 installed.
> The test server is a Windows 2000 Server. The production server has SQL
> Server 2000 installed also, but it is a Windows 2003 Server. I have found,
> for example, that I can define an ODBC DSN to the test database and
> retrieve
> data just fine, but I can NOT do the same thing to the production database
> on the production server. However, our users were able to do so up until
> Tuesday of this week. The only thing I can think of which has changed is I
> applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
> the DHCP server. But the DHCP server is not either the production or test
> database servers, so I have no idea why that should make any difference at
> all.
> Does anyone have any idea why this problem is now showing up?
> Rod
>
>

Getting "SQL Server does not exist or access denied" error messages

For some reason, this week we started to get "SQL Server does not exist or
access denied" error messages when attempting to connect to our SQL Server
databases. This only affects people who dial into our network. But this
seems to be a rather complicated situation, so let me explain.
We have a couple of VB6 applications we've written. People log into our
network and get authenticated on our network (username, password and domain
must be specified). We have a test server with SQL Server 2000 installed.
The test server is a Windows 2000 Server. The production server has SQL
Server 2000 installed also, but it is a Windows 2003 Server. I have found,
for example, that I can define an ODBC DSN to the test database and retrieve
data just fine, but I can NOT do the same thing to the production database
on the production server. However, our users were able to do so up until
Tuesday of this week. The only thing I can think of which has changed is I
applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
the DHCP server. But the DHCP server is not either the production or test
database servers, so I have no idea why that should make any difference at
all.
Does anyone have any idea why this problem is now showing up?
RodHi Rod,
If this is was fine before, then I would suspect that it is an issue related
to the security. Usually this error happens when client does not have
permissions to connect to the SQL Server. Could be that last changes in a
fixes were related to the security issues. Do you know which patches were
installed exactly. If yes, then you could check KB articles for them to see
if installation of them does not change any security settings.
--
Val Mazur
Microsoft MVP
"Rod" <Rod@.NO.SPAM> wrote in message
news:u05d8jpaEHA.4092@.TK2MSFTNGP11.phx.gbl...
> For some reason, this week we started to get "SQL Server does not exist or
> access denied" error messages when attempting to connect to our SQL Server
> databases. This only affects people who dial into our network. But this
> seems to be a rather complicated situation, so let me explain.
> We have a couple of VB6 applications we've written. People log into our
> network and get authenticated on our network (username, password and
> domain
> must be specified). We have a test server with SQL Server 2000 installed.
> The test server is a Windows 2000 Server. The production server has SQL
> Server 2000 installed also, but it is a Windows 2003 Server. I have found,
> for example, that I can define an ODBC DSN to the test database and
> retrieve
> data just fine, but I can NOT do the same thing to the production database
> on the production server. However, our users were able to do so up until
> Tuesday of this week. The only thing I can think of which has changed is I
> applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
> the DHCP server. But the DHCP server is not either the production or test
> database servers, so I have no idea why that should make any difference at
> all.
> Does anyone have any idea why this problem is now showing up?
> Rod
>
>

Getting "SQL Server does not exist or access denied" error messages

For some reason, this week we started to get "SQL Server does not exist or
access denied" error messages when attempting to connect to our SQL Server
databases. This only affects people who dial into our network. But this
seems to be a rather complicated situation, so let me explain.
We have a couple of VB6 applications we've written. People log into our
network and get authenticated on our network (username, password and domain
must be specified). We have a test server with SQL Server 2000 installed.
The test server is a Windows 2000 Server. The production server has SQL
Server 2000 installed also, but it is a Windows 2003 Server. I have found,
for example, that I can define an ODBC DSN to the test database and retrieve
data just fine, but I can NOT do the same thing to the production database
on the production server. However, our users were able to do so up until
Tuesday of this week. The only thing I can think of which has changed is I
applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
the DHCP server. But the DHCP server is not either the production or test
database servers, so I have no idea why that should make any difference at
all.
Does anyone have any idea why this problem is now showing up?
RodHi Rod,
None of the recent updates would impact SQL or client connectivity
(MDAC).
What is the OS error when the ODBC DSN fails?
Is this only happening over a VPN or can you repro this locally as well?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Rod,
If this is was fine before, then I would suspect that it is an issue related
to the security. Usually this error happens when client does not have
permissions to connect to the SQL Server. Could be that last changes in a
fixes were related to the security issues. Do you know which patches were
installed exactly. If yes, then you could check KB articles for them to see
if installation of them does not change any security settings.
Val Mazur
Microsoft MVP
"Rod" <Rod@.NO.SPAM> wrote in message
news:u05d8jpaEHA.4092@.TK2MSFTNGP11.phx.gbl...
> For some reason, this week we started to get "SQL Server does not exist or
> access denied" error messages when attempting to connect to our SQL Server
> databases. This only affects people who dial into our network. But this
> seems to be a rather complicated situation, so let me explain.
> We have a couple of VB6 applications we've written. People log into our
> network and get authenticated on our network (username, password and
> domain
> must be specified). We have a test server with SQL Server 2000 installed.
> The test server is a Windows 2000 Server. The production server has SQL
> Server 2000 installed also, but it is a Windows 2003 Server. I have found,
> for example, that I can define an ODBC DSN to the test database and
> retrieve
> data just fine, but I can NOT do the same thing to the production database
> on the production server. However, our users were able to do so up until
> Tuesday of this week. The only thing I can think of which has changed is I
> applied the 5 critical updates that Microsoft related Tuesday/Wednesday on
> the DHCP server. But the DHCP server is not either the production or test
> database servers, so I have no idea why that should make any difference at
> all.
> Does anyone have any idea why this problem is now showing up?
> Rod
>
>|||I am having a similar problem. i am not very experienced programmer and
wrote a program in vb.net which connected fine to my local copy of sql.
the db admin set up ODBC's for the remote servers and i got the same
error. i tried using odbc's on my local machine and fixing the
problem, but i can't for the life of me figure it out. When i test the
connection in the odbc setup,it connects great. i just cannot do it
via the program. I used the odbc connection string and put the
passwords and id in the string code before i try to open the
connection. very confused. any help would be greatly appreciated.
thanks
Chris
Val Mazur wrote:[vbcol=seagreen]
> *Hi Rod,
> If this is was fine before, then I would suspect that it is an issue
> related
> to the security. Usually this error happens when client does not
> have
> permissions to connect to the SQL Server. Could be that last changes
> in a
> fixes were related to the security issues. Do you know which patches
> were
> installed exactly. If yes, then you could check KB articles for them
> to see
> if installation of them does not change any security settings.
> --
> Val Mazur
> Microsoft MVP
>
> "Rod" <Rod@.NO.SPAM> wrote in message
> news:u05d8jpaEHA.4092@.TK2MSFTNGP11.phx.gbl...
> exist or
> Server
> this
> our
> and
> installed.
> SQL
> found,
> and
> database
> until
> changed is I
> Tuesday/Wednesday on
> or test
> difference at
ringo
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message862704.html|||So, if local connections work, but remote connections fail. I would
suggest making some network traces to verify that we're using the right
protocols and able to resolve the machine name.
run the following commands from a DOS prompt:
ipconfig /flushdns
ipconfig /registerdns
Then.
start Microsoft Network Monitor
Attempt a connection using your program.
stop Microsoft Network Monitor.
Review the trace.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I believe I have found the problem. The user has Norton Internet Security
2003 (or 2004, I am not sure which) installed. Once I disabled that, I was
able to reach the server.
Rod
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:AjXJoyAdEHA.3808@.cpmsftngxa10.phx.gbl...
> So, if local connections work, but remote connections fail. I would
> suggest making some network traces to verify that we're using the right
> protocols and able to resolve the machine name.
> run the following commands from a DOS prompt:
> ipconfig /flushdns
> ipconfig /registerdns
> Then.
> start Microsoft Network Monitor
> Attempt a connection using your program.
> stop Microsoft Network Monitor.
> Review the trace.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||Kevin , thanks for your response.
I may not have been as clear as i should have been. After the initial
failed attempt of putting the program onto a local computer with the DB
on a separate server, i tried to re-create the problem on my own
laptop. I have made an ODBC which calls the sql on my machine. My
theory is that this would recreate the same process as if it were on a
centralized server. I still get the SQL SERVER DOES NOT EXIST OR
ACCESS NOT DENIED. I don't get it tho. when i create the ODBC, it
tests successfully. Also, when i create a new connection string, and
choose ODBC driver and the correct odbc name (which appears, so it sees
the odbc list) IT also tests successfully. However, when i try to run
the program just opening the conn, it gives the error. I thought i had
fixed it becuase one odbc name i created happened to be the same name
as my local server, so it didnt' give the error, but im thinking it
didn't use the odbc, it just called the local server.
I did the ipconfig/ things you suggested. I am not familiar wiht
Microsoft Network Monitor. Should i continue with this possible
resolution?
thanks so much,
Chris
Kevin McDonnell [MSFT] wrote:
> *So, if local connections work, but remote connections fail. I
> would
> suggest making some network traces to verify that we're using the
> right
> protocols and able to resolve the machine name.
> run the following commands from a DOS prompt:
> ipconfig /flushdns
> ipconfig /registerdns
> Then.
> start Microsoft Network Monitor
> Attempt a connection using your program.
> stop Microsoft Network Monitor.
> Review the trace.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no
> rights. *
ringo
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message862704.html|||Hi Ringo,
Unfortunately, you can't make network traces of local connections. Try
using ISQL.exe locally to see if it will generate the OS error for you.
Also check the HKLM\Software\Microsoft\MSSQLServer\Clie
nt\ConnectTo key:
the only entry should be DSQUERY set to DBNETLIB.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql