Connectivty problem from NON domain users

I have a problem esteblishing a connection to a SQL server with a SQL user,
while I am logged to the computer with a local computer.
Any domain account can has no problem.
What can ause this?
Thanks in advance,
Ido Friedman
What tool are you connecting from?
How are you trying to connect?
Do you know for sure that you are trying to connect via SQL Authentication?
Have you tried hitting the Data Sources (ODBC) applet within the Control
Panel and creating a test connection?
Keith Kratochvil
"Ido friedman" <Idofriedman@.discussions.microsoft.com> wrote in message
news:934F22F5-2624-49B2-AC35-1970C1AE876D@.microsoft.com...
>I have a problem esteblishing a connection to a SQL server with a SQL user,
> while I am logged to the computer with a local computer.
> Any domain account can has no problem.
> What can ause this?
> Thanks in advance,
> Ido Friedman
|||Do you have mixed mode authentication enabled?
To enable...
SQL 2005
In SQL Server Management Studio Object Explorer, right-click your server,
and then click Properties.
On the Security page, under Server authentication, select the new server
authentication mode, and then click OK.
In the SQL Server Management Studio dialog box, click OK, to acknowledge the
need to restart SQL Server.
SQL 2000
Expand a server group.
Right-click a server, and then click Properties.
Click the Security tab.
Under Authentication, click SQL Server and Windows.
Under Audit level, select the level at which user accesses to Microsoft SQL
ServerT are recorded in the SQL Server error log:
None causes no auditing to be performed.
Success causes only successful login attempts to be audited.
Failure causes only failed login attempts to be audited.
All causes successful and failed login attempts to be audited.
Hope that helps...
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Ido friedman" <Idofriedman@.discussions.microsoft.com> wrote in message
news:934F22F5-2624-49B2-AC35-1970C1AE876D@.microsoft.com...
>I have a problem esteblishing a connection to a SQL server with a SQL user,
> while I am logged to the computer with a local computer.
> Any domain account can has no problem.
> What can ause this?
> Thanks in advance,
> Ido Friedman
|||Thanks for your reply,
I am using the following ASP page:
The page is running in IIS under the local user IUser_computername.
When I run the same code with a domain account it successeds.
Thanks in advance,
Ido Friedman
<%
Dim dataSource
On Error Resume Next
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA
SOURCE=servername";UID=user;PWD=user;DATABASE=nort hwind"
If err.number = 0 Then
Response.Write(cnn.State)
cnn.Close
Else
Response.Write( err.Description )
End If
Response.End
%>
"Warren Brunk" wrote:

> Do you have mixed mode authentication enabled?
> To enable...
> SQL 2005
> In SQL Server Management Studio Object Explorer, right-click your server,
> and then click Properties.
> On the Security page, under Server authentication, select the new server
> authentication mode, and then click OK.
> In the SQL Server Management Studio dialog box, click OK, to acknowledge the
> need to restart SQL Server.
>
> SQL 2000
> Expand a server group.
>
> Right-click a server, and then click Properties.
>
> Click the Security tab.
>
> Under Authentication, click SQL Server and Windows.
>
> Under Audit level, select the level at which user accesses to Microsoft? SQL
> ServerT are recorded in the SQL Server error log:
> None causes no auditing to be performed.
>
> Success causes only successful login attempts to be audited.
>
> Failure causes only failed login attempts to be audited.
>
> All causes successful and failed login attempts to be audited.
>
> Hope that helps...
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Ido friedman" <Idofriedman@.discussions.microsoft.com> wrote in message
> news:934F22F5-2624-49B2-AC35-1970C1AE876D@.microsoft.com...
>
>

Connectivity to excel from a different domain

Hi,

I would like to know if anybody has successfully connected to Analysis services cube using Excel 2007 over a different domain using the msmdpump ? I am able to connect it over the intranet, but if I try to connect from any other outside environment it fails to connect .

My analysis server and IIS are configured on the same box.

Any suggestions most welcome.

Thanks

JK

I have no problem with connecting over HTTP to the server in another domain. For example, DSP Panel runs open server in Internet - I just connected to it from Excel - just put the following in the wizard: http://demo.dspanel.com/olap/msmdpump.dll

HTH,

Mosha (http://www.mosha.com/msolap)

|||

This sounds like a firewall/routing problem. Might be worth trying to get some networking admin to help out.

In the meantime, can you connect to the IIS server for normal content?

sqlsql

Connection to SQL Express ONLY with integrated security but WITHOUT domain

Does anybody know if it is possible to establish a connection to an sql express instance only with integrated security when this express instance is running on XP which is NOT part of a domain?

Thanks,

Klaus

If the SQL Express machine isn't connected to a domain then I don't believe Kerberos authentication will work but NTLM authentication should work. If the client application is running on the same machine as SQL Express then you should be able to straightforwardly give a user account local to the machine permission to connect to SQL Express (machine administrators will have it by default). If you're connecting from off-box then I think you'll need to setup the same account (same user name & password) on the remote machine.

Hope that helps.

Vaughn

Connection String Question.

This summary is not available. Please click here to view the post.

Connection String Question.

This summary is not available. Please click here to view the post.

Connection refused, connecting to SQL server through web

Hi,
I'm trying to connect to an SQL server from an asp.net
page. Both servers are in the same domain.
The setting on the SQL server are set to accept both
Windows and SQL users.
The users of the webserver log in with windows
authentication.
First I tried to connect to the SQL server using the
Administrator account of the web server. This was no
succes and got the message: SQL Server does not exist or
access denied
After that I changed both administrator accounts to the
same password and tried to connect. Now the connection
was succesfull.
But, if I try to connect from the web I still get the
message: SQL Server does not exist or access denied.
Does anybody have an solution for this problem?
Greetings,
TomNot a quick and easy answer. Very details steps are outlined here;
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/SecNetch05.asp
This assumes you machines are in Active Directory. If not you can follow
this older article;
176380 How To Use ASP with a SQL Trusted Connection with Guest Account
http://support.microsoft.com/?id=176380
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you,
this really helpt.
>--Original Message--
>Not a quick and easy answer. Very details steps are
outlined here;
>Building Secure ASP.NET Applications: Authentication,
Authorization, and
>Secure Communication
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnnetsec/ht
>ml/SecNetch05.asp
>This assumes you machines are in Active Directory. If
not you can follow
>this older article;
>176380 How To Use ASP with a SQL Trusted Connection with
Guest Account
>http://support.microsoft.com/?id=176380
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||You're welcome!
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connection refused, connecting to SQL server through web

Hi,
I'm trying to connect to an SQL server from an asp.net
page. Both servers are in the same domain.
The setting on the SQL server are set to accept both
Windows and SQL users.
The users of the webserver log in with windows
authentication.
First I tried to connect to the SQL server using the
Administrator account of the web server. This was no
succes and got the message: SQL Server does not exist or
access denied
After that I changed both administrator accounts to the
same password and tried to connect. Now the connection
was succesfull.
But, if I try to connect from the web I still get the
message: SQL Server does not exist or access denied.
Does anybody have an solution for this problem?
Greetings,
Tom
Not a quick and easy answer. Very details steps are outlined here;
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn.microsoft.com/library/de...us/dnnetsec/ht
ml/SecNetch05.asp
This assumes you machines are in Active Directory. If not you can follow
this older article;
176380 How To Use ASP with a SQL Trusted Connection with Guest Account
http://support.microsoft.com/?id=176380
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thank you,
this really helpt.
>--Original Message--
>Not a quick and easy answer. Very details steps are
outlined here;
>Building Secure ASP.NET Applications: Authentication,
Authorization, and
>Secure Communication
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnnetsec/ht
>ml/SecNetch05.asp
>This assumes you machines are in Active Directory. If
not you can follow
>this older article;
>176380 How To Use ASP with a SQL Trusted Connection with
Guest Account
>http://support.microsoft.com/?id=176380
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||You're welcome!
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connection problem: ASP.NET on machine and SQL Server on another

If anyone knows the answer to this Id me greatly appreciative.
I am not on a domain.
I have SQL Server sitting on computer A
Computer A has:
Windows XP SP2
SQL Server 2000 SP3a
SQL Server is set to use Trusted or SQL authorization
I have added a user X to SQL Server with a password of X
I am writing an ASP.NET app on Computer B. IIS and Dev on B)
I am trying to make a connection to SQL on computer A but get the
error SQL Server does not exist or access denied
Now when I create a small Winforms app as a test, I can use the exact
same connection string and open a connection to SQL Server just fine.
So, Im guessing the problems lies in the security of ASP.NET, but Im
not sure what to change to make this work.
Anyone with any ideas?
TIA
B
I should also point out, I can also connect just fine withn the same
user/pw with Enterprise Mager, and Query Analyzer as well as add the
connection to Visual Studio.
B
Brian W wrote:

> If anyone knows the answer to this Id me greatly appreciative.
> I am not on a domain.
> I have SQL Server sitting on computer A
> Computer A has:
> Windows XP SP2
> SQL Server 2000 SP3a
> SQL Server is set to use Trusted or SQL authorization
> I have added a user X to SQL Server with a password of X
> I am writing an ASP.NET app on Computer B. IIS and Dev on B)
> I am trying to make a connection to SQL on computer A but get the
> error SQL Server does not exist or access denied
> Now when I create a small Winforms app as a test, I can use the exact
> same connection string and open a connection to SQL Server just fine.
> So, Im guessing the problems lies in the security of ASP.NET, but Im
> not sure what to change to make this work.
> Anyone with any ideas?
> TIA
> B

Connection problem: ASP.NET on machine and SQL Server on another

If anyone knows the answer to this Id me greatly appreciative.
I am not on a domain.
I have SQL Server sitting on computer A
Computer A has:
Windows XP SP2
SQL Server 2000 SP3a
SQL Server is set to use Trusted or SQL authorization
I have added a user X to SQL Server with a password of X
I am writing an ASP.NET app on Computer B. IIS and Dev on B)
I am trying to make a connection to SQL on computer A but get the
error SQL Server does not exist or access denied
Now when I create a small Winforms app as a test, I can use the exact
same connection string and open a connection to SQL Server just fine.
So, Im guessing the problems lies in the security of ASP.NET, but Im
not sure what to change to make this work.
Anyone with any ideas?
TIA
BI should also point out, I can also connect just fine withn the same
user/pw with Enterprise Mager, and Query Analyzer as well as add the
connection to Visual Studio.
B
Brian W wrote:

> If anyone knows the answer to this Id me greatly appreciative.
> I am not on a domain.
> I have SQL Server sitting on computer A
> Computer A has:
> Windows XP SP2
> SQL Server 2000 SP3a
> SQL Server is set to use Trusted or SQL authorization
> I have added a user X to SQL Server with a password of X
> I am writing an ASP.NET app on Computer B. IIS and Dev on B)
> I am trying to make a connection to SQL on computer A but get the
> error SQL Server does not exist or access denied
> Now when I create a small Winforms app as a test, I can use the exact
> same connection string and open a connection to SQL Server just fine.
> So, Im guessing the problems lies in the security of ASP.NET, but Im
> not sure what to change to make this work.
> Anyone with any ideas?
> TIA
> B