asp sql server: domain

Showing posts with label domain. Show all posts

Sunday, March 11, 2012

Connection from other domain failes

Hi,
i like to use my Excel pivot from other domain, but I always get the error message "Cannot find repository". I tried a ping on IP of analysis server, no problem. The connection string includes the IP adress as well. Anybody knows the clue ?
Thx
dajmI have to re-post my question, hopefully anybody got same problem.

Here my problem again:

A client from other (trusted) domain can ping to my analysis server, but cannot use the excel pivot table using the cube of same analysis server. It is saying "Cannot find repository".
Pivottable is working fine from same domain as analysis server.

Any clue ?

dajm|||Where is repository of your Analysis Server located? In access file msmdrep in Binn directory of AS (default) or in SQL Server msdb database (after migration)? mojza|||Thx. for reply.

repository path is standard path of SQL server.

Anyway, I made this workaround:

I have chosen authentication over http protocol and it works fine now.
Any disadvantages I can expect from this solution ?

dajm

Wednesday, March 7, 2012

Connection Failed

I have added a domain global group to the local administrators group on server running sql 2000 with sp3a. The os on the server is w2k with sp4. The builtin\administrators group has sa rights. Yet members of the domain global group, after they logon to the server through a remote desktop session cannot open sql enterprise manager & connect to the local sql server (default instance). They get a message "Cannot open user default database. Login failed.." The users of the domain global group can connect to 2 other instances of of sql on the same server. The default instance is 8.00.818. The other 2 instances are 8.00.760. Thanks in advance for any advice.

*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...7b2402cee65437e
*****************************************Mike Pavel via SQLMonster.com (forum@.SQLMonster.com) writes:
> I have added a domain global group to the local administrators group on
> server running sql 2000 with sp3a. The os on the server is w2k with sp4.
> The builtin\administrators group has sa rights. Yet members of the
> domain global group, after they logon to the server through a remote
> desktop session cannot open sql enterprise manager & connect to the
> local sql server (default instance). They get a message "Cannot open
> user default database. Login failed.." The users of the domain global
> group can connect to 2 other instances of of sql on the same server. The
> default instance is 8.00.818. The other 2 instances are 8.00.760. Thanks
> in advance for any advice.

Each login on an SQL Server has a default database. Now, if for some
reason they cannot access that database, login fails. This can be
because they don't have permission to the database or that database is
offline of non-existing.

You can use the stored procedure sp_defaultdb to change the default db
for a user. Please see Books Online for syntax.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||The domain global group is part of the nt local admins group on the server running sql which makes it part of the built\administrators group in sql which has dbo access to all the databases on the sql server. The default database does exist. Thanks for reponding to my question. Any more thoughts?

*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...sql-server/5079
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...bfff59ba325a2b2
*****************************************|||Mike Pavel via SQLMonster.com (forum@.SQLMonster.com) writes:
> The domain global group is part of the nt local admins group on the
> server running sql which makes it part of the built\administrators group
> in sql which has dbo access to all the databases on the sql server. The
> default database does exist. Thanks for reponding to my question. Any
> more thoughts?

Well, the error message you get, usually means that the default database
is not accessible. This can be because of several reasons:

o The database does not exist.
o The user does not have permission to the database.
o The database is offline or in single-user mode.

Can they log in through Query Analyzer or OSQL? In such case, change the
registration properties in Enterprise Manager.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Sunday, February 19, 2012

Connection between two domains

Hi All,
We have two different domains in our environment, say ABC and XYZ, and they
are not trusted. I login into my PC using ABC domain .
I have windows authenticated login in SQLServer that is in XYZ domain.
Can anyone tell me how I can connect to SQL server that is in different
domain using Enterprise Manager or query analyzer?
Thanks,
VinodHi,
You can try doing a Run As ...
Shift + Right Click on EM shortcut and select Run As ...
Enter your other domain user credentials in the form:
domain\username
password
I'm not 100% sure that this will work though. Is your computer a member of
both domains?
It will somehow have to authenticate your credentials with the other domain.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and
> they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||I believe that your only option is to create the same account (and same password) in both domains.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"VM" <VM@.discussions.microsoft.com> wrote in message
news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> Hi All,
> We have two different domains in our environment, say ABC and XYZ, and they
> are not trusted. I login into my PC using ABC domain .
> I have windows authenticated login in SQLServer that is in XYZ domain.
> Can anyone tell me how I can connect to SQL server that is in different
> domain using Enterprise Manager or query analyzer?
> Thanks,
> Vinod
>|||Hi Dan,
Thanks for the info. This is working. But it is failing for SQLServers
that are in ABC domain. It looks like I have to maintain two different
shortcuts for Enterprise manager one for each domain.
Thanks,
Vinod
"dan artuso" wrote:
> Hi,
> You can try doing a Run As ...
> Shift + Right Click on EM shortcut and select Run As ...
> Enter your other domain user credentials in the form:
> domain\username
> password
> I'm not 100% sure that this will work though. Is your computer a member of
> both domains?
> It will somehow have to authenticate your credentials with the other domain.
> --
> HTH
> Dan Artuso
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and
> > they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>
>|||Hi Tibor,
I tried using the same account and same passwords in both the domains, but
that didnot work.
Thanks,
Vinod
"Tibor Karaszi" wrote:
> I believe that your only option is to create the same account (and same password) in both domains.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "VM" <VM@.discussions.microsoft.com> wrote in message
> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
> > Hi All,
> >
> > We have two different domains in our environment, say ABC and XYZ, and they
> > are not trusted. I login into my PC using ABC domain .
> >
> > I have windows authenticated login in SQLServer that is in XYZ domain.
> >
> > Can anyone tell me how I can connect to SQL server that is in different
> > domain using Enterprise Manager or query analyzer?
> >
> > Thanks,
> > Vinod
> >
>|||Hi,
Yes, you would never be able to see servers from both domains in one
instance of EM.
--
HTH
Dan Artuso
"VM" <VM@.discussions.microsoft.com> wrote in message
news:63AA4081-792D-4267-8347-DAE6F36A5716@.microsoft.com...
> Hi Dan,
> Thanks for the info. This is working. But it is failing for SQLServers
> that are in ABC domain. It looks like I have to maintain two different
> shortcuts for Enterprise manager one for each domain.
> Thanks,
> Vinod
> "dan artuso" wrote:
>> Hi,
>> You can try doing a Run As ...
>> Shift + Right Click on EM shortcut and select Run As ...
>> Enter your other domain user credentials in the form:
>> domain\username
>> password
>> I'm not 100% sure that this will work though. Is your computer a member
>> of
>> both domains?
>> It will somehow have to authenticate your credentials with the other
>> domain.
>> --
>> HTH
>> Dan Artuso
>>
>> "VM" <VM@.discussions.microsoft.com> wrote in message
>> news:43B7970B-20A6-465E-8083-5D1C6C25FF59@.microsoft.com...
>> > Hi All,
>> >
>> > We have two different domains in our environment, say ABC and XYZ, and
>> > they
>> > are not trusted. I login into my PC using ABC domain .
>> >
>> > I have windows authenticated login in SQLServer that is in XYZ domain.
>> >
>> > Can anyone tell me how I can connect to SQL server that is in different
>> > domain using Enterprise Manager or query analyzer?
>> >
>> > Thanks,
>> > Vinod
>> >
>>

Connection between two domains

Friday, February 17, 2012

Connecting via VPN

Your machine and the customer's are not in the same domain so Windows
authentication won't work because there's no way to authenticate the user on
your machine. SQL Auth should work unless there's something else blocking
the TCP/IP connection. It might help to know what error you're getting and
if there is an error in the server error log. Running EM remotely is
actually the best solution in this case.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Middletree" <middletree@.hottttttttmail.com> wrote in message
news:OitGvBWlGHA.4772@.TK2MSFTNGP04.phx.gbl...
> One my company's customers has allowed me to connect to their network via
> VPN. Overall, it seems to work fine. I can remote in, or map drives, etc.
> However, I have been unable to use my SQL2000 Enterprise manager to
> connect to their database. I can remote into the machine where that
> database resides and open up EM there, but I can't do it from EM on my
> machine. That is, I'm getting a 'logon failed' error, regardless of
> whether or not I am using Windows or SQL authentication.
> I did some digging, and found that ports 1433 and 1434 need to be open for
> this to happen. However, the customer has stated that he isn't blocking
> off these ports.
> Anyone know of any issues with doing this over VPN?
>One my company's customers has allowed me to connect to their network via
VPN. Overall, it seems to work fine. I can remote in, or map drives, etc.
However, I have been unable to use my SQL2000 Enterprise manager to connect
to their database. I can remote into the machine where that database resides
and open up EM there, but I can't do it from EM on my machine. That is, I'm
getting a 'logon failed' error, regardless of whether or not I am using
Windows or SQL authentication.
I did some digging, and found that ports 1433 and 1434 need to be open for
this to happen. However, the customer has stated that he isn't blocking off
these ports.
Anyone know of any issues with doing this over VPN?|||Your machine and the customer's are not in the same domain so Windows
authentication won't work because there's no way to authenticate the user on
your machine. SQL Auth should work unless there's something else blocking
the TCP/IP connection. It might help to know what error you're getting and
if there is an error in the server error log. Running EM remotely is
actually the best solution in this case.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Middletree" <middletree@.hottttttttmail.com> wrote in message
news:OitGvBWlGHA.4772@.TK2MSFTNGP04.phx.gbl...
> One my company's customers has allowed me to connect to their network via
> VPN. Overall, it seems to work fine. I can remote in, or map drives, etc.
> However, I have been unable to use my SQL2000 Enterprise manager to
> connect to their database. I can remote into the machine where that
> database resides and open up EM there, but I can't do it from EM on my
> machine. That is, I'm getting a 'logon failed' error, regardless of
> whether or not I am using Windows or SQL authentication.
> I did some digging, and found that ports 1433 and 1434 need to be open for
> this to happen. However, the customer has stated that he isn't blocking
> off these ports.
> Anyone know of any issues with doing this over VPN?
>|||[vbcol=seagreen]
And your local firewall (if any)?
Try to connect with telnet on port 1433 and/or osql or sqlcmd with the
"tcp:"-prefix.
More infor here
http://blogs.msdn.com/sql_protocols.../22/483684.aspx
And the remote connection is not always the best solution - perhaps the
local machine is a development-station for test and debugging - porting
changes is a whole lot easier with local access...
/ola|||[vbcol=seagreen]
And your local firewall (if any)?
Try to connect with telnet on port 1433 and/or osql or sqlcmd with the
"tcp:"-prefix.
More infor here
http://blogs.msdn.com/sql_protocols.../22/483684.aspx
And the remote connection is not always the best solution - perhaps the
local machine is a development-station for test and debugging - porting
changes is a whole lot easier with local access...
/ola

Sunday, February 12, 2012

Connecting to SQL Server using non domain account

How can I connect to SQL Server 2005 without having a domain account and thr
ough a MS Access front end that is on the main server
and shared between 20 different users? Some of the users have domain account
s and they can use the database, but those that do not
have domain accounts cannot connect. Is there a way to get this working?
Cheers,
Max.Do you have a database administrator for the SQL Server? Someone will
need to create SQL logins and grant permissions in the database.
--Mary
On Thu, 11 Jan 2007 15:14:36 -0500, "Max" <maxy_100@.yahoo.com> wrote:

>How can I connect to SQL Server 2005 without having a domain account and th
rough a MS Access front end that is on the main server
>and shared between 20 different users? Some of the users have domain accoun
ts and they can use the database, but those that do not
>have domain accounts cannot connect. Is there a way to get this working?
>Cheers,
>Max.

Connecting to SQL Server using non domain account

How can I connect to SQL Server 2005 without having a domain account and through a MS Access front end that is on the main server
and shared between 20 different users? Some of the users have domain accounts and they can use the database, but those that do not
have domain accounts cannot connect. Is there a way to get this working?
Cheers,
Max.Do you have a database administrator for the SQL Server? Someone will
need to create SQL logins and grant permissions in the database.
--Mary
On Thu, 11 Jan 2007 15:14:36 -0500, "Max" <maxy_100@.yahoo.com> wrote:
>How can I connect to SQL Server 2005 without having a domain account and through a MS Access front end that is on the main server
>and shared between 20 different users? Some of the users have domain accounts and they can use the database, but those that do not
>have domain accounts cannot connect. Is there a way to get this working?
>Cheers,
>Max.

Connecting to SQL Server of another domain

Please help me to find the solution for following problem.

I have my web server (with .NET 2.0 Framework) in one Domain(DMS01) where i have deployed my application (developed in ASP.NET 2.0). I have to access the database (SQL Server 2000) that belongs to another Domain(DMS02). How could i connect to the database that belongs to domain DMS02 from Web Application belonging to domain DMS01.

Thanks in advanced for help.

To start with, you need to check on how you connect to the database. If you are on different domains then it will be hard for you to use integrated security, unless you use impersonation. So easiest thing is to go for sql authentication. This means that you need to define a user in DMS02 SQL server that has access to the database/tables that you need. Then make sure this SQL server accepts remote connections. You will also need the ip address of this SQL server.

You can test your connection in SQL Management Studio Express, where you can connect to the DMS02 SQL server with the specified credentials. Once it work, you should put this information in your connection string. Good luck!

|||

Let your DB server expose to the other doamin (DMS01) [So from your database server can access to either DMS01 or DMS02 domain]
Now, go to your application web.config file and make sure you typed the correct UserID with the right domain

Example: UserID = DMS02\MyUser

Good luck

|||

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

i am getting this error when i use following connection string(My database server is SQL Server 2000)

|||

bikashdangol:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
i am getting this error when i use following connection string(My database server is SQL Server 2000)

<add name="MyConnectionString"
connectionString="Data Source=DMS02\MSSQLSERVER;Initial Catalog=DatabseName;user id='sa';password='sa123'"
providerName="System.Data.SqlClient"/>

Check out this link:http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx

Good luck.

|||

Hi bikashdangol,

According to the error message you are getting now, It seems when you connecting to the data server, sql server client cannot locate the server machine. Can you verify if you can access machines in DMS02 from your domain?( these two domains need to build a trusted relationship before you can access machines accross domains). Another possibility is the sql server service is truned off OR allow remote connection is disabled. You can contact the server DBA for clarification.

Hope my suggestion helps

connecting to sql server in another domain in vbs

I am trying to connect to a sql server database that is in another domain
from a vb script (not within ASP, just .vbs file). I am getting error:
Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server
Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.
Can someone guide me to any articles or guides on how to get this
accomplished in vbs?
Thanks!
There are a lot of articles - hard to narrow down which may
apply in your case. Are you trying to connect with windows
authentication? Are you by chance using a DSN? What
authentication mode is the server set to?
If you are trying to use a SQL login, did you make sure to
specify the user and password?
These articles may give you an idea of what to look at:
http://support.microsoft.com/?id=827422
http://support.microsoft.com/?id=889615
http://support.microsoft.com/?id=307002
-Sue
On Fri, 16 Sep 2005 09:59:06 -0700, "slimbim"
<slimbim@.discussions.microsoft.com> wrote:

>I am trying to connect to a sql server database that is in another domain
>from a vb script (not within ASP, just .vbs file). I am getting error:
>Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server
>Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated
>with a trusted SQL Server connection.
>Can someone guide me to any articles or guides on how to get this
>accomplished in vbs?
>Thanks!

connecting to sql server in another domain in vbs

I am trying to connect to a sql server database that is in another domain
from a vb script (not within ASP, just .vbs file). I am getting error:
Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Ser
ver
Driver][SQL Server]Login failed for user '(null)'. Reason: Not associate
d
with a trusted SQL Server connection.
Can someone guide me to any articles or guides on how to get this
accomplished in vbs?
Thanks!There are a lot of articles - hard to narrow down which may
apply in your case. Are you trying to connect with windows
authentication? Are you by chance using a DSN? What
authentication mode is the server set to?
If you are trying to use a SQL login, did you make sure to
specify the user and password?
These articles may give you an idea of what to look at:
http://support.microsoft.com/?id=827422
http://support.microsoft.com/?id=889615
http://support.microsoft.com/?id=307002
-Sue
On Fri, 16 Sep 2005 09:59:06 -0700, "slimbim"
<slimbim@.discussions.microsoft.com> wrote:

>I am trying to connect to a sql server database that is in another domain
>from a vb script (not within ASP, just .vbs file). I am getting error:
>Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Se
rver
>Driver][SQL Server]Login failed for user '(null)'. Reason: Not associat
ed
>with a trusted SQL Server connection.
>Can someone guide me to any articles or guides on how to get this
>accomplished in vbs?
>Thanks!

Connecting to SQL Server from IIS in DMZ

My Web Server is standalone, in a DMZ and not a member of the domain the SQL server belongs to. The SQL server is internal and behind a firewall.

I followed the recommendations on Microsoft's website Using the ASP.NET process identity
and local mirrored ASPNET accounts:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch12.asp

But get the error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

From what I read in the document it should try and connect with the ASPNET Process identity.

I have tested with Impersonation using a local windows account and UserID and Password in the connection string and can connect to the SQL server through the firewall so the relevant ports etc are open.

However I don't want to have user Id's and passwords in the connection string and would like to use integrated security.

Pls help as I am tearing all my hair out!!!!!This must be frustrating for you.

Could you post the connection string that is failing and maybe that will spark the answer?

Terri|||Thanks for your reply, however I organised a contractor to come in and check it out and when I showed him what the problem was it didn't happen and everything worked ok!!

Arrrggghhh!!! And nothing at all has/was changed.

Typical...

Cheers|||I have the EXACT same problem, only mine isn't fixing itself! I used the mirrored local ASPNET account and I am getting the login failed for user '(null)' message.

Connection string is: Data Source=<server name>;Initial Catalog=<database name>;Integrated Security=SSPI;

Any ideas?|||I spent hours upon hours trying to fix it.
Have you changed the 'machine' password in machine.config to match your local ASPNET Account?

Basically I changed that and set up the accounts and I got the error you are talking about, it came right by itself, when I think back it is possible I did a reboot of the webserver.|||You were right, I just needed to reboot the webserver. I guess the thing to remember is always reboot when you change machine.cofig.

Thanks, Cove!|||No problem. Probably stopping and starting the relevant services would have done the trick too??

Sunday, March 11, 2012

Connection from other domain failes

Wednesday, March 7, 2012

Connection Failed

Sunday, February 19, 2012

Connection between two domains

Connection between two domains

Connection between two domains

Friday, February 17, 2012

Connecting via VPN

Sunday, February 12, 2012

Connecting to SQL Server using non domain account

Connecting to SQL Server using non domain account

Connecting to SQL Server of another domain

connecting to sql server in another domain in vbs

connecting to sql server in another domain in vbs

Connecting to SQL Server from IIS in DMZ

asp sql server

Blog Archive

About Me