Connecting to SQL

I have a problem in connecting to an SQL database on a server from laptop
computers. The users can access it from a desktop with same windows login as
they use on their laptop but all I get when they try on the laptop is an
error message saying connection failure. All machines are running XP and we
cannot find any differences in the setup.
If anyone has any advise or can point me in the right direction I would be
greatful.
TIA
Rob
Hi Rob,
Do you use sqlserver authentication or windows authentication on the
sqlserver ?
Ton
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> I have a problem in connecting to an SQL database on a server from laptop
> computers. The users can access it from a desktop with same windows login
as
> they use on their laptop but all I get when they try on the laptop is an
> error message saying connection failure. All machines are running XP and
we
> cannot find any differences in the setup.
> If anyone has any advise or can point me in the right direction I would be
> greatful.
> TIA
> Rob
>
>
|||windows authentication. Although this has been partly resolved. The laptops
have been assigned fixed IP addresses which has allowed them to connect.
However I would ideally prefer a different workaround as fixed IP addresses
are not ideal.
Thanks
"Ton" <t.leer@.wanadoo.nl> wrote in message
news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
> Hi Rob,
> Do you use sqlserver authentication or windows authentication on the
> sqlserver ?
> Ton
> "Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
> news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> as
> we
>
|||This is a DNS issue and is not really related to SQL Server.
Michael Otey
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:O1Ljfq4tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> windows authentication. Although this has been partly resolved. The
laptops
> have been assigned fixed IP addresses which has allowed them to connect.
> However I would ideally prefer a different workaround as fixed IP
addresses[vbcol=seagreen]
> are not ideal.
> Thanks
> "Ton" <t.leer@.wanadoo.nl> wrote in message
> news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
laptop[vbcol=seagreen]
login[vbcol=seagreen]
an[vbcol=seagreen]
and
>

Connecting to SQL

I have a problem in connecting to an SQL database on a server from laptop
computers. The users can access it from a desktop with same windows login as
they use on their laptop but all I get when they try on the laptop is an
error message saying connection failure. All machines are running XP and we
cannot find any differences in the setup.
If anyone has any advise or can point me in the right direction I would be
greatful.
TIA
RobHi Rob,
Do you use sqlserver authentication or windows authentication on the
sqlserver ?
Ton
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> I have a problem in connecting to an SQL database on a server from laptop
> computers. The users can access it from a desktop with same windows login
as
> they use on their laptop but all I get when they try on the laptop is an
> error message saying connection failure. All machines are running XP and
we
> cannot find any differences in the setup.
> If anyone has any advise or can point me in the right direction I would be
> greatful.
> TIA
> Rob
>
>|||windows authentication. Although this has been partly resolved. The laptops
have been assigned fixed IP addresses which has allowed them to connect.
However I would ideally prefer a different workaround as fixed IP addresses
are not ideal.
Thanks
"Ton" <t.leer@.wanadoo.nl> wrote in message
news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
> Hi Rob,
> Do you use sqlserver authentication or windows authentication on the
> sqlserver ?
> Ton
> "Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
> news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> as
> we
>|||This is a DNS issue and is not really related to SQL Server.
Michael Otey
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:O1Ljfq4tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> windows authentication. Although this has been partly resolved. The
laptops
> have been assigned fixed IP addresses which has allowed them to connect.
> However I would ideally prefer a different workaround as fixed IP
addresses
> are not ideal.
> Thanks
> "Ton" <t.leer@.wanadoo.nl> wrote in message
> news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
laptop[vbcol=seagreen]
login[vbcol=seagreen]
an[vbcol=seagreen]
and[vbcol=seagreen]
>

connecting sql server

i created a database, when i query a simple select statement , i get an
error:
"Cannot open database requested in login 'XYZ_Database'.
Login fails, Login failed for user 'sa''
But when i change , the database name to Northwind, it works.
i checked that user rights of 'sa' for XYZ_database and Northwind are the
same?
i get the same error, when i used integrated security to connect too.
what would be the case here?
Hi,
It seems the database creator/owner might be some other user.
Execute the below command to check the database owner:-
sp_helpdb 'XYZ_Database'
If the owner is a non SA user , then change the database owner using:-
sp_changedbowner system procedure (Refer books online for information)
Thanks
Hari
MCDBA
"e-mid" <someone@.somewhere> wrote in message
news:#uip9U6VEHA.208@.TK2MSFTNGP10.phx.gbl...
> i created a database, when i query a simple select statement , i get an
> error:
> "Cannot open database requested in login 'XYZ_Database'.
> Login fails, Login failed for user 'sa''
>
> But when i change , the database name to Northwind, it works.
> i checked that user rights of 'sa' for XYZ_database and Northwind are the
> same?
> i get the same error, when i used integrated security to connect too.
> what would be the case here?
>
|||Hari;
user of the database seems to be sa; here is the properties of the database:
"XYZ_database 3.00 MB sa 7 Jun 21 2004 Status=ONLINE,
Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0,
IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
80"
what else can be the problem?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Sh3WY6VEHA.1144@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Hi,
> It seems the database creator/owner might be some other user.
> Execute the below command to check the database owner:-
> sp_helpdb 'XYZ_Database'
> If the owner is a non SA user , then change the database owner using:-
> sp_changedbowner system procedure (Refer books online for information)
> Thanks
> Hari
> MCDBA
>
>
> "e-mid" <someone@.somewhere> wrote in message
> news:#uip9U6VEHA.208@.TK2MSFTNGP10.phx.gbl...
the
>
|||i am becoming insane.
i did not change even a letter but it is working now ?!
"e-mid" <someone@.somewhere> wrote in message
news:u7BQSe6VEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hari;
> user of the database seems to be sa; here is the properties of the
database:[vbcol=seagreen]
> "XYZ_database 3.00 MB sa 7 Jun 21 2004 Status=ONLINE,
> Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
> Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0,
> IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
> 80"
> what else can be the problem?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:#Sh3WY6VEHA.1144@.TK2MSFTNGP10.phx.gbl...
an
> the
>
|||Good.
Thanks
Hari
MCDBA
"e-mid" <someone@.somewhere> wrote in message
news:OFRlQt6VEHA.2408@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> i am becoming insane.
> i did not change even a letter but it is working now ?!
>
> "e-mid" <someone@.somewhere> wrote in message
> news:u7BQSe6VEHA.2520@.TK2MSFTNGP12.phx.gbl...
> database:
IsAutoUpdateStatistics[vbcol=seagreen]
> an
are[vbcol=seagreen]
too.
>

connecting sql server

i created a database, when i query a simple select statement , i get an
error:
"Cannot open database requested in login 'XYZ_Database'.
Login fails, Login failed for user 'sa''
But when i change , the database name to Northwind, it works.
i checked that user rights of 'sa' for XYZ_database and Northwind are the
same?
i get the same error, when i used integrated security to connect too.
what would be the case here?Hi,
It seems the database creator/owner might be some other user.
Execute the below command to check the database owner:-
sp_helpdb 'XYZ_Database'
If the owner is a non SA user , then change the database owner using:-
sp_changedbowner system procedure (Refer books online for information)
Thanks
Hari
MCDBA
"e-mid" <someone@.somewhere> wrote in message
news:#uip9U6VEHA.208@.TK2MSFTNGP10.phx.gbl...
> i created a database, when i query a simple select statement , i get an
> error:
> "Cannot open database requested in login 'XYZ_Database'.
> Login fails, Login failed for user 'sa''
>
> But when i change , the database name to Northwind, it works.
> i checked that user rights of 'sa' for XYZ_database and Northwind are the
> same?
> i get the same error, when i used integrated security to connect too.
> what would be the case here?
>|||Hari;
user of the database seems to be sa; here is the properties of the database:
"XYZ_database 3.00 MB sa 7 Jun 21 2004 Status=ONLINE,
Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0,
IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
80"
what else can be the problem?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Sh3WY6VEHA.1144@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It seems the database creator/owner might be some other user.
> Execute the below command to check the database owner:-
> sp_helpdb 'XYZ_Database'
> If the owner is a non SA user , then change the database owner using:-
> sp_changedbowner system procedure (Refer books online for information)
> Thanks
> Hari
> MCDBA
>
>
> "e-mid" <someone@.somewhere> wrote in message
> news:#uip9U6VEHA.208@.TK2MSFTNGP10.phx.gbl...
> > i created a database, when i query a simple select statement , i get an
> > error:
> >
> > "Cannot open database requested in login 'XYZ_Database'.
> > Login fails, Login failed for user 'sa''
> >
> >
> > But when i change , the database name to Northwind, it works.
> >
> > i checked that user rights of 'sa' for XYZ_database and Northwind are
the
> > same?
> >
> > i get the same error, when i used integrated security to connect too.
> >
> > what would be the case here?
> >
> >
>|||i am becoming insane.
i did not change even a letter but it is working now '!
"e-mid" <someone@.somewhere> wrote in message
news:u7BQSe6VEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hari;
> user of the database seems to be sa; here is the properties of the
database:
> "XYZ_database 3.00 MB sa 7 Jun 21 2004 Status=ONLINE,
> Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
> Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0,
> IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
> 80"
> what else can be the problem?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:#Sh3WY6VEHA.1144@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > It seems the database creator/owner might be some other user.
> >
> > Execute the below command to check the database owner:-
> >
> > sp_helpdb 'XYZ_Database'
> >
> > If the owner is a non SA user , then change the database owner using:-
> >
> > sp_changedbowner system procedure (Refer books online for information)
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > "e-mid" <someone@.somewhere> wrote in message
> > news:#uip9U6VEHA.208@.TK2MSFTNGP10.phx.gbl...
> > > i created a database, when i query a simple select statement , i get
an
> > > error:
> > >
> > > "Cannot open database requested in login 'XYZ_Database'.
> > > Login fails, Login failed for user 'sa''
> > >
> > >
> > > But when i change , the database name to Northwind, it works.
> > >
> > > i checked that user rights of 'sa' for XYZ_database and Northwind are
> the
> > > same?
> > >
> > > i get the same error, when i used integrated security to connect too.
> > >
> > > what would be the case here?
> > >
> > >
> >
> >
>|||Good. :)
Thanks
Hari
MCDBA
"e-mid" <someone@.somewhere> wrote in message
news:OFRlQt6VEHA.2408@.tk2msftngp13.phx.gbl...
> i am becoming insane.
> i did not change even a letter but it is working now '!
>
> "e-mid" <someone@.somewhere> wrote in message
> news:u7BQSe6VEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Hari;
> >
> > user of the database seems to be sa; here is the properties of the
> database:
> >
> > "XYZ_database 3.00 MB sa 7 Jun 21 2004 Status=ONLINE,
> >
> > Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
> >
> > Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0,
> >
> > IsTornPageDetectionEnabled, IsAutoCreateStatistics,
IsAutoUpdateStatistics
> > 80"
> >
> > what else can be the problem?
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> > news:#Sh3WY6VEHA.1144@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > It seems the database creator/owner might be some other user.
> > >
> > > Execute the below command to check the database owner:-
> > >
> > > sp_helpdb 'XYZ_Database'
> > >
> > > If the owner is a non SA user , then change the database owner using:-
> > >
> > > sp_changedbowner system procedure (Refer books online for information)
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > >
> > > "e-mid" <someone@.somewhere> wrote in message
> > > news:#uip9U6VEHA.208@.TK2MSFTNGP10.phx.gbl...
> > > > i created a database, when i query a simple select statement , i get
> an
> > > > error:
> > > >
> > > > "Cannot open database requested in login 'XYZ_Database'.
> > > > Login fails, Login failed for user 'sa''
> > > >
> > > >
> > > > But when i change , the database name to Northwind, it works.
> > > >
> > > > i checked that user rights of 'sa' for XYZ_database and Northwind
are
> > the
> > > > same?
> > > >
> > > > i get the same error, when i used integrated security to connect
too.
> > > >
> > > > what would be the case here?
> > > >
> > > >
> > >
> > >
> >
> >
>

connecting sql server

i created a database, when i query a simple select statement , i get an
error:
"Cannot open database requested in login 'XYZ_Database'.
Login fails, Login failed for user 'sa''
But when i change , the database name to Northwind, it works.
i checked that user rights of 'sa' for XYZ_database and Northwind are the
same?
i get the same error, when i used integrated security to connect too.
what would be the case here?Hi,
It seems the database creator/owner might be some other user.
Execute the below command to check the database owner:-
sp_helpdb 'XYZ_Database'
If the owner is a non SA user , then change the database owner using:-
sp_changedbowner system procedure (Refer books online for information)
Thanks
Hari
MCDBA
"e-mid" <someone@.somewhere> wrote in message
news:#uip9U6VEHA.208@.TK2MSFTNGP10.phx.gbl...
> i created a database, when i query a simple select statement , i get an
> error:
> "Cannot open database requested in login 'XYZ_Database'.
> Login fails, Login failed for user 'sa''
>
> But when i change , the database name to Northwind, it works.
> i checked that user rights of 'sa' for XYZ_database and Northwind are the
> same?
> i get the same error, when i used integrated security to connect too.
> what would be the case here?
>|||Hari;
user of the database seems to be sa; here is the properties of the database:
"XYZ_database 3.00 MB sa 7 Jun 21 2004 Status=ONLINE,
Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0,
IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
80"
what else can be the problem?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Sh3WY6VEHA.1144@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It seems the database creator/owner might be some other user.
> Execute the below command to check the database owner:-
> sp_helpdb 'XYZ_Database'
> If the owner is a non SA user , then change the database owner using:-
> sp_changedbowner system procedure (Refer books online for information)
> Thanks
> Hari
> MCDBA
>
>
> "e-mid" <someone@.somewhere> wrote in message
> news:#uip9U6VEHA.208@.TK2MSFTNGP10.phx.gbl...
the[vbcol=seagreen]
>|||i am becoming insane.
i did not change even a letter but it is working now '!
"e-mid" <someone@.somewhere> wrote in message
news:u7BQSe6VEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hari;
> user of the database seems to be sa; here is the properties of the
database:
> "XYZ_database 3.00 MB sa 7 Jun 21 2004 Status=ONLINE,
> Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
> Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0,
> IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
> 80"
> what else can be the problem?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:#Sh3WY6VEHA.1144@.TK2MSFTNGP10.phx.gbl...
an[vbcol=seagreen]
> the
>|||Good.
Thanks
Hari
MCDBA
"e-mid" <someone@.somewhere> wrote in message
news:OFRlQt6VEHA.2408@.tk2msftngp13.phx.gbl...
> i am becoming insane.
> i did not change even a letter but it is working now '!
>
> "e-mid" <someone@.somewhere> wrote in message
> news:u7BQSe6VEHA.2520@.TK2MSFTNGP12.phx.gbl...
> database:
IsAutoUpdateStatistics[vbcol=seagreen]
> an
are[vbcol=seagreen]
too.[vbcol=seagreen]
>

Connecting RS to another server

When I run an RS report on server1 that connects to a sql database on server2
I get the error:
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "
Suggestions?On Jun 7, 1:50 pm, Jimbo <J...@.discussions.microsoft.com> wrote:
> When I run an RS report on server1 that connects to a sql database on server2
> I get the error:
> "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "
> Suggestions?
Refer to Reeves Smith's response to your other posting. That would be
my suggestion as well.
Regards,
Enrique Martinez
Sr. Software Consultant

Connecting from VB without knowing login/passwd?

Hello
One of our customers who uses a MS SQL-based application asked
us if we could write an add-on. We've never used MS SQL before. From
what I've read, it seems like ADO requires a login/password to connect
to it.
Problem is, the customer doesn't have this piece of information, and
although customers own the data, we don't want to ask the company that
built the main application because our add-on does something similar
to what they do (but better :-)).
Is there a way to either bypass the login/password phase, or sniff it
from the network? We just want to read data, not write anything to MS
SQL.
Thank you.> Is there a way to either bypass the login/password phase, or sniff it
> from the network?
that would pretty much defeat security in the first place...
Have your DBA create a login using appropriate permission in the database and specify that login. Of
course, that login could either be a SQL login (where you specify the login name when you connect)
or a login based on the Windows user (where you specify to use integrated authentication).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gilles Ganault" <nospam@.nospam.com> wrote in message
news:1e1t831pk775sk5hlcha1uoaha07jfhb4l@.4ax.com...
> Hello
> One of our customers who uses a MS SQL-based application asked
> us if we could write an add-on. We've never used MS SQL before. From
> what I've read, it seems like ADO requires a login/password to connect
> to it.
> Problem is, the customer doesn't have this piece of information, and
> although customers own the data, we don't want to ask the company that
> built the main application because our add-on does something similar
> to what they do (but better :-)).
> Is there a way to either bypass the login/password phase, or sniff it
> from the network? We just want to read data, not write anything to MS
> SQL.
> Thank you.|||On Jul 6, 2:14 pm, Gilles Ganault <nos...@.nospam.com> wrote:
> Hello
> One of our customers who uses a MS SQL-based application asked
> us if we could write an add-on. We've never used MS SQL before. From
> what I've read, it seems like ADO requires a login/password to connect
> to it.
> Problem is, the customer doesn't have this piece of information, and
> although customers own the data, we don't want to ask the company that
> built the main application because our add-on does something similar
> to what they do (but better :-)).
> Is there a way to either bypass the login/password phase, or sniff it
> from the network? We just want to read data, not write anything to MS
> SQL.
> Thank you.
Or grant the Windows group that the connecting user belongs to the
same permissions that the other app is using.
Then from VB use "integrated security"|||On Fri, 6 Jul 2007 20:19:59 +0200, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>Have your DBA create a login using appropriate permission in the database and specify that login
I don't know if the customer even has admin access to their own MS SQL
server, but I'll ask.
Thanks guys.

Connecting from VB without knowing login/passwd?

Hello
One of our customers who uses a MS SQL-based application asked
us if we could write an add-on. We've never used MS SQL before. From
what I've read, it seems like ADO requires a login/password to connect
to it.
Problem is, the customer doesn't have this piece of information, and
although customers own the data, we don't want to ask the company that
built the main application because our add-on does something similar
to what they do (but better :-)).
Is there a way to either bypass the login/password phase, or sniff it
from the network? We just want to read data, not write anything to MS
SQL.
Thank you.
> Is there a way to either bypass the login/password phase, or sniff it
> from the network?
that would pretty much defeat security in the first place...
Have your DBA create a login using appropriate permission in the database and specify that login. Of
course, that login could either be a SQL login (where you specify the login name when you connect)
or a login based on the Windows user (where you specify to use integrated authentication).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gilles Ganault" <nospam@.nospam.com> wrote in message
news:1e1t831pk775sk5hlcha1uoaha07jfhb4l@.4ax.com...
> Hello
> One of our customers who uses a MS SQL-based application asked
> us if we could write an add-on. We've never used MS SQL before. From
> what I've read, it seems like ADO requires a login/password to connect
> to it.
> Problem is, the customer doesn't have this piece of information, and
> although customers own the data, we don't want to ask the company that
> built the main application because our add-on does something similar
> to what they do (but better :-)).
> Is there a way to either bypass the login/password phase, or sniff it
> from the network? We just want to read data, not write anything to MS
> SQL.
> Thank you.
|||On Jul 6, 2:14 pm, Gilles Ganault <nos...@.nospam.com> wrote:
> Hello
> One of our customers who uses a MS SQL-based application asked
> us if we could write an add-on. We've never used MS SQL before. From
> what I've read, it seems like ADO requires a login/password to connect
> to it.
> Problem is, the customer doesn't have this piece of information, and
> although customers own the data, we don't want to ask the company that
> built the main application because our add-on does something similar
> to what they do (but better :-)).
> Is there a way to either bypass the login/password phase, or sniff it
> from the network? We just want to read data, not write anything to MS
> SQL.
> Thank you.
Or grant the Windows group that the connecting user belongs to the
same permissions that the other app is using.
Then from VB use "integrated security"
|||On Fri, 6 Jul 2007 20:19:59 +0200, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>Have your DBA create a login using appropriate permission in the database and specify that login
I don't know if the customer even has admin access to their own MS SQL
server, but I'll ask.
Thanks guys.

Connecting from VB without knowing login/passwd?

Hello
One of our customers who uses a MS SQL-based application asked
us if we could write an add-on. We've never used MS SQL before. From
what I've read, it seems like ADO requires a login/password to connect
to it.
Problem is, the customer doesn't have this piece of information, and
although customers own the data, we don't want to ask the company that
built the main application because our add-on does something similar
to what they do (but better :-)).
Is there a way to either bypass the login/password phase, or sniff it
from the network? We just want to read data, not write anything to MS
SQL.
Thank you.> Is there a way to either bypass the login/password phase, or sniff it
> from the network?
that would pretty much defeat security in the first place...
Have your DBA create a login using appropriate permission in the database an
d specify that login. Of
course, that login could either be a SQL login (where you specify the login
name when you connect)
or a login based on the Windows user (where you specify to use integrated au
thentication).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gilles Ganault" <nospam@.nospam.com> wrote in message
news:1e1t831pk775sk5hlcha1uoaha07jfhb4l@.
4ax.com...
> Hello
> One of our customers who uses a MS SQL-based application asked
> us if we could write an add-on. We've never used MS SQL before. From
> what I've read, it seems like ADO requires a login/password to connect
> to it.
> Problem is, the customer doesn't have this piece of information, and
> although customers own the data, we don't want to ask the company that
> built the main application because our add-on does something similar
> to what they do (but better :-)).
> Is there a way to either bypass the login/password phase, or sniff it
> from the network? We just want to read data, not write anything to MS
> SQL.
> Thank you.|||On Jul 6, 2:14 pm, Gilles Ganault <nos...@.nospam.com> wrote:
> Hello
> One of our customers who uses a MS SQL-based application asked
> us if we could write an add-on. We've never used MS SQL before. From
> what I've read, it seems like ADO requires a login/password to connect
> to it.
> Problem is, the customer doesn't have this piece of information, and
> although customers own the data, we don't want to ask the company that
> built the main application because our add-on does something similar
> to what they do (but better :-)).
> Is there a way to either bypass the login/password phase, or sniff it
> from the network? We just want to read data, not write anything to MS
> SQL.
> Thank you.
Or grant the Windows group that the connecting user belongs to the
same permissions that the other app is using.
Then from VB use "integrated security"|||On Fri, 6 Jul 2007 20:19:59 +0200, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>Have your DBA create a login using appropriate permission in the database and speci
fy that login
I don't know if the customer even has admin access to their own MS SQL
server, but I'll ask.
Thanks guys.

Connecting a user from a backup database to a new login

All,
In SQL Server 2000, I loaded a backup file into a new local database.
The database has an existing user which owns several stored procedures,
tables, etc.
Using SQL Server authentication, I want to create a login of the same
name as the user, so that when I login, I have access to the objects
owned by that user without having to prefix the objects with the owner
name.
For instance exec sp_mystoredproc instead of exec
ownername.sp_mystoredproc. (In fact, several of the stored procedures
exec other procedures without the owner name prefix and to go add the
owner will be a tedious process)
When I try to add login and grant the login name to the existing user
it tells me it already exists.
I cannot drop the existing user because it owns a whole bunch of
objects.
What can I do to work around this? How do I connect a login to an
existing database user? Is there a system table where I can just map
the two?
Brad> What can I do to work around this? How do I connect a login to an
> existing database user? Is there a system table where I can just map
> the two?
See the sp_change_users_login stored procedure in the Books Online. Also,
the Best Practice is to always schema-qualify objects.
Hope this helps.
Dan Guzman
SQL Server MVP
"brad" <brad.eckrose@.gmail.com> wrote in message
news:1168719405.103237.233140@.38g2000cwa.googlegroups.com...
> All,
> In SQL Server 2000, I loaded a backup file into a new local database.
> The database has an existing user which owns several stored procedures,
> tables, etc.
> Using SQL Server authentication, I want to create a login of the same
> name as the user, so that when I login, I have access to the objects
> owned by that user without having to prefix the objects with the owner
> name.
> For instance exec sp_mystoredproc instead of exec
> ownername.sp_mystoredproc. (In fact, several of the stored procedures
> exec other procedures without the owner name prefix and to go add the
> owner will be a tedious process)
> When I try to add login and grant the login name to the existing user
> it tells me it already exists.
> I cannot drop the existing user because it owns a whole bunch of
> objects.
> What can I do to work around this? How do I connect a login to an
> existing database user? Is there a system table where I can just map
> the two?
> Brad
>

connecting

hi,
I recently added a new login/pwd for a database I couldnt connect through my
asp application. Now I can, which is nice. But, now I can't connect to other
databases. I have an adp project and when I try to pull it up, I get the
message that there's a problem connecting. I do get it , but it says
"disconnected" at the top of the Access application. My question is this:
can I have a database that requires windows and sql server authentication,
then one that only requires windows authentication connected to the same
server? Could this be where my problem is? Should I remove that sql server
authentication ?
thanks-Hi Leo,
Thank you for using MSDN Managed Newsgroup Support.
From you description, my understanding of this issue is: You want to use
the SQL authentication to connect to the SQL server in the access adp
project but all the application is disconnected. If I misunderstood your
concern, please feel free to let me know.
If you could connect to the SQL Server in ASP application with your SQL
account, this account should be OK. As for the disconnected issue in
Access, I would like to know some information:
1. What's the Office Version and if you have applied the latest Services
Pack of Office?
2. If you use other SQL login account, does this issue appeared? If you use
SA account, does this issue appeared? What about using Windows account?
3. What's the SQL Server Version? Is SQL 2000 or SQL 7.0 or SQL 2005?
Please let me know the information so that I can provide further assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
To answer your questions I am using:
1. Ms Office 2003 SP1
2. SQL Server 2000
I can't connect to any of the databases in Enterprise Manager today. I also
cannot connect to my database via the ASP application. Here's what I did:
1. I had a database that I could not connect to. Somebody suggested that I
set up a sql authentication for it and use that in the asp code. I did, it
worked. However,
after that, I could not open my other database ( which I use in an ade
application). This was working great before - I used windows authentication
only for this one.
2. Because of my problem, i thought if I added the user/password on my SQL
authentication access to my other database, I would be ok. Well, now I am in
worse shape. I tried to connect to each of the databases to Test the
connection in "Administrative Tools", but my test fails all the time. How d
o
I connect those databases back to Enterprise Manager, so I can see them? I
have a bad feeling that I had to start all over again from scratch.
thanks,
Maggie
"Wei Lu [MSFT]" wrote:

> Hi Leo,
> Thank you for using MSDN Managed Newsgroup Support.
> From you description, my understanding of this issue is: You want to use
> the SQL authentication to connect to the SQL server in the access adp
> project but all the application is disconnected. If I misunderstood your
> concern, please feel free to let me know.
> If you could connect to the SQL Server in ASP application with your SQL
> account, this account should be OK. As for the disconnected issue in
> Access, I would like to know some information:
> 1. What's the Office Version and if you have applied the latest Services
> Pack of Office?
> 2. If you use other SQL login account, does this issue appeared? If you us
e
> SA account, does this issue appeared? What about using Windows account?
> 3. What's the SQL Server Version? Is SQL 2000 or SQL 7.0 or SQL 2005?
> Please let me know the information so that I can provide further assistanc
e.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
>|||Hi Maggie,
Thank you for the update.
From the symptom you meet, I suggest you to make sure the account you use
to connect to the sql server have proper permission to access all the
databases. Please try to login the computer which host SQL Server as the
local administrator and try to connect to the SQL Server to see does all
the database is there. Also, you could use the SA account to connect to the
SQL Server.
If so, please goto the Security section to add the SQL account to the
sysadmin server role to check does this issue appeared or not.
Please let me know the result so that I can provide further assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||hi Wei,
I had to uninstall Sql Server and reinstall it because I was never able to
access the server. Each time I tried to, it would give me an error message
and I didn't understand what I could have done anyway. It's very confusing t
o
me because I never worked with Sql before!
I do have one question though. If I set up Sql Server ( on the install ) as
windows authentication , then add another login/password to access a new
database, then attach it to this server, what changes do I make to the serve
r
properties?
Do I change it to mixed mode? How/where do I do that? Or do I set it up on
mixed mode first?
My second question is: if I do set up an additional login/password to
access a database( because I must do this in my ASP script ), what affect
does this have on the other databases? Do I give this new login/psswd acces
s
to the other pre-existing datbases?
thanks -
"Wei Lu [MSFT]" wrote:

> Hi Maggie,
> Thank you for the update.
> From the symptom you meet, I suggest you to make sure the account you use
> to connect to the sql server have proper permission to access all the
> databases. Please try to login the computer which host SQL Server as the
> local administrator and try to connect to the SQL Server to see does all
> the database is there. Also, you could use the SA account to connect to th
e
> SQL Server.
> If so, please goto the Security section to add the SQL account to the
> sysadmin server role to check does this issue appeared or not.
> Please let me know the result so that I can provide further assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi Maggie,
Thank you for the update.
For the first question, you need to use Mixed Mode to enable to use the SQL
Authentication. You could set it up when you install the SQL Server. Also,
you could change it after installation.
To change the Authentication mode, please do the following:
1. Open the Enterprise Manager, expand the server group to find your
server, right-click and click Properties.
2. Click Security Tab, and in the Authentication section, check to select
SQL Server and Windows. Then Click OK.
3. Restart the SQL Server.
For your second question, when you set the Login to access a database, if
you do not add it to any Server Role, by default, it could not access
other databases.
But you could configure this in the Database Access Tab of the New Login
Dialogbox.
Here is the article for your reference:
SQL Server Login Properties - New Login
http://msdn.microsoft.com/library/d...-us/entrmgr/em_
76zy.asp
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

Connect to SQL with NT authentication from form...

I have a login page that checks the given userid/password against ADSI and redirects the user if successful. My problem seems to come when I try to connect to the SQL database with the user's NT credentials. I have the user's NT account setup in SQL, have anony. disabled in IIS, using Integrated Windows Security in IIS, and am using the following connection string:

connectionString = "data source=SqlServer;initial catalog=pubs;Trusted_Connection=Yes"

I also have this entry in my Web.Config file: <identity impersonate="true" /
Actually, it seems to connect OK, but I can not select any data. I just receive "Select permission denied..." errors even though the user has been given these permissions in SQL.

Any advice would be greatly appreciated.

Thanks,
-BenYou need to set the proper access rights in for the User in SQL Server itself.|||The user has all the proper permissions on the SQL server.

Connect to SQL Server from machine not in domain

I am attempting to connect to a SQL Server that is in a domain that I
have a VPN connection to. I am receiving the Error: "Login failed for
user '(null)'. Reason: Not associated with a trusted SQL Server
connection. (Microsoft SQL Server, Error: 18452)
I errantly had expected that by mapping a drive to one of the shares
on the SQL Server that I am attempting to connect to, that I would be
able to connect ok using Integrated Windows Authentication. I have
even renamed my local UID/pwd to match that on the domain that owns
the SQL Server I am attempting to connect to.
Thoughts?Hi
If you have granted login to that user or a domain group on the domain where
the sql server is (where the user is a member) , then you should be able to
log in even though the user is in a different domain. If you can't grant the
login and if you can't change the way the domains trust each other, then you
will need to ue SQL Authentication.
John
"brandor" wrote:
> I am attempting to connect to a SQL Server that is in a domain that I
> have a VPN connection to. I am receiving the Error: "Login failed for
> user '(null)'. Reason: Not associated with a trusted SQL Server
> connection. (Microsoft SQL Server, Error: 18452)
> I errantly had expected that by mapping a drive to one of the shares
> on the SQL Server that I am attempting to connect to, that I would be
> able to connect ok using Integrated Windows Authentication. I have
> even renamed my local UID/pwd to match that on the domain that owns
> the SQL Server I am attempting to connect to.
> Thoughts?
>

connect to sql server 2005 problem

I tried to run MS SQL server management studio with sa login. But it gives
an error as following:
Cannot connect to the server:
Additional information:
A connection waas successfully established with the server, but then an
error occured during the
login process. (provider: Shared Memory Provider, error:0 - No process is on
other end of the
pipe.) (Microsoft SQL Server, error:233)
Does anyone know what is the problem and how to fix it? THanksHi
"00MichaelJordan" wrote:
> I tried to run MS SQL server management studio with sa login. But it gives
> an error as following:
> Cannot connect to the server:
> Additional information:
> A connection waas successfully established with the server, but then an
> error occured during the
> login process. (provider: Shared Memory Provider, error:0 - No process is on
> other end of the
> pipe.) (Microsoft SQL Server, error:233)
I assume you are on the server itself when you try and connect? Can you
sucessfully connect using windows authentication?
Checking Google for your error message came up with:
http://msdn2.microsoft.com/en-us/library/ms175496.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
Check the client and server protocols installed. Check any antivirus or
intrusion detection systems installed on the server is not interferring.
> Does anyone know what is the problem and how to fix it? THanks
>
John|||Yes, I can login with window authentication.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:2DDB7F0E-DE41-467C-8A7E-1BAF6EBBEDF1@.microsoft.com...
> Hi
> "00MichaelJordan" wrote:
>> I tried to run MS SQL server management studio with sa login. But it
>> gives
>> an error as following:
>> Cannot connect to the server:
>> Additional information:
>> A connection waas successfully established with the server, but then an
>> error occured during the
>> login process. (provider: Shared Memory Provider, error:0 - No process is
>> on
>> other end of the
>> pipe.) (Microsoft SQL Server, error:233)
> I assume you are on the server itself when you try and connect? Can you
> sucessfully connect using windows authentication?
> Checking Google for your error message came up with:
> http://msdn2.microsoft.com/en-us/library/ms175496.aspx
> http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
> Check the client and server protocols installed. Check any antivirus or
> intrusion detection systems installed on the server is not interferring.
>> Does anyone know what is the problem and how to fix it? THanks
> John|||Hi
On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> Yes, I can login with window authentication.
>
You don't say if this is a local or remote connection!
Have you tried creating a new SQL Server Login and tried to use that?
Have you set the default database for sa?
Has this databases been moved from a different machine?
John|||John,
This is a local connection. The default database for sa is
master and I have created a new sql server account and I cannot login with
the new account as well and this database is moved from a SQL 2000 server.
Please help. Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1170405046.429970.295550@.s48g2000cws.googlegroups.com...
> Hi
> On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
>> Yes, I can login with window authentication.
> You don't say if this is a local or remote connection!
> Have you tried creating a new SQL Server Login and tried to use that?
> Have you set the default database for sa?
> Has this databases been moved from a different machine?
> John
>
>|||Hi
On Feb 6, 3:08 am, " 00EricClapton" <E...@.yahoo.com> wrote:
> John,
> This is a local connection. The default database for sa is
> master and I have created a new sql server account and I cannot login with
> the new account as well and this database is moved from a SQL 2000 server.
> Please help. Thanks.
>
As you can log in with windows authentication then make sure that the
server is set to used mixed mode. Are you using Query Analyser to log
in? Try using the server's IP address instead of the server name,
'(local)' or '.'. You could also try removing the shared memory
setting on the protocol.
John

connect to sql server 2005 problem

I tried to run MS SQL server management studio with sa login. But it gives
an error as following:
Cannot connect to the server:
Additional information:
A connection waas successfully established with the server, but then an
error occured during the
login process. (provider: Shared Memory Provider, error:0 - No process is on
other end of the
pipe.) (Microsoft SQL Server, error:233)
Does anyone know what is the problem and how to fix it? THanks
Hi
"00MichaelJordan" wrote:

> I tried to run MS SQL server management studio with sa login. But it gives
> an error as following:
> Cannot connect to the server:
> Additional information:
> A connection waas successfully established with the server, but then an
> error occured during the
> login process. (provider: Shared Memory Provider, error:0 - No process is on
> other end of the
> pipe.) (Microsoft SQL Server, error:233)
I assume you are on the server itself when you try and connect? Can you
sucessfully connect using windows authentication?
Checking Google for your error message came up with:
http://msdn2.microsoft.com/en-us/library/ms175496.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
Check the client and server protocols installed. Check any antivirus or
intrusion detection systems installed on the server is not interferring.

> Does anyone know what is the problem and how to fix it? THanks
>
John
|||Yes, I can login with window authentication.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:2DDB7F0E-DE41-467C-8A7E-1BAF6EBBEDF1@.microsoft.com...
> Hi
> "00MichaelJordan" wrote:
>
> I assume you are on the server itself when you try and connect? Can you
> sucessfully connect using windows authentication?
> Checking Google for your error message came up with:
> http://msdn2.microsoft.com/en-us/library/ms175496.aspx
> http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
> Check the client and server protocols installed. Check any antivirus or
> intrusion detection systems installed on the server is not interferring.
>
> John
|||Hi
On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> Yes, I can login with window authentication.
>
You don't say if this is a local or remote connection!
Have you tried creating a new SQL Server Login and tried to use that?
Have you set the default database for sa?
Has this databases been moved from a different machine?
John
|||John,
This is a local connection. The default database for sa is
master and I have created a new sql server account and I cannot login with
the new account as well and this database is moved from a SQL 2000 server.
Please help. Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1170405046.429970.295550@.s48g2000cws.googlegr oups.com...
> Hi
> On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> You don't say if this is a local or remote connection!
> Have you tried creating a new SQL Server Login and tried to use that?
> Have you set the default database for sa?
> Has this databases been moved from a different machine?
> John
>
>
|||Hi
On Feb 6, 3:08 am, " 00EricClapton" <E...@.yahoo.com> wrote:
> John,
> This is a local connection. The default database for sa is
> master and I have created a new sql server account and I cannot login with
> the new account as well and this database is moved from a SQL 2000 server.
> Please help. Thanks.
>
As you can log in with windows authentication then make sure that the
server is set to used mixed mode. Are you using Query Analyser to log
in? Try using the server's IP address instead of the server name,
'(local)' or '.'. You could also try removing the shared memory
setting on the protocol.
John

connect to sql server 2005 problem

I tried to run MS SQL server management studio with sa login. But it gives
an error as following:
Cannot connect to the server:
Additional information:
A connection waas successfully established with the server, but then an
error occured during the
login process. (provider: Shared Memory Provider, error:0 - No process is on
other end of the
pipe.) (Microsoft SQL Server, error:233)
Does anyone know what is the problem and how to fix it? THanksHi
"00MichaelJordan" wrote:

> I tried to run MS SQL server management studio with sa login. But it gives
> an error as following:
> Cannot connect to the server:
> Additional information:
> A connection waas successfully established with the server, but then an
> error occured during the
> login process. (provider: Shared Memory Provider, error:0 - No process is
on
> other end of the
> pipe.) (Microsoft SQL Server, error:233)
I assume you are on the server itself when you try and connect? Can you
sucessfully connect using windows authentication?
Checking Google for your error message came up with:
http://msdn2.microsoft.com/en-us/library/ms175496.aspx
http://blogs.msdn.com/sql_protocols.../22/483684.aspx
Check the client and server protocols installed. Check any antivirus or
intrusion detection systems installed on the server is not interferring.

> Does anyone know what is the problem and how to fix it? THanks
>
John|||Yes, I can login with window authentication.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:2DDB7F0E-DE41-467C-8A7E-1BAF6EBBEDF1@.microsoft.com...
> Hi
> "00MichaelJordan" wrote:
>
> I assume you are on the server itself when you try and connect? Can you
> sucessfully connect using windows authentication?
> Checking Google for your error message came up with:
> http://msdn2.microsoft.com/en-us/library/ms175496.aspx
> http://blogs.msdn.com/sql_protocols.../22/483684.aspx
> Check the client and server protocols installed. Check any antivirus or
> intrusion detection systems installed on the server is not interferring.
>
> John|||Hi
On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> Yes, I can login with window authentication.
>
You don't say if this is a local or remote connection!
Have you tried creating a new SQL Server Login and tried to use that?
Have you set the default database for sa?
Has this databases been moved from a different machine?
John|||John,
This is a local connection. The default database for sa is
master and I have created a new sql server account and I cannot login with
the new account as well and this database is moved from a SQL 2000 server.
Please help. Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1170405046.429970.295550@.s48g2000cws.googlegroups.com...
> Hi
> On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> You don't say if this is a local or remote connection!
> Have you tried creating a new SQL Server Login and tried to use that?
> Have you set the default database for sa?
> Has this databases been moved from a different machine?
> John
>
>|||Hi
On Feb 6, 3:08 am, " 00EricClapton" <E...@.yahoo.com> wrote:
> John,
> This is a local connection. The default database for sa is
> master and I have created a new sql server account and I cannot login with
> the new account as well and this database is moved from a SQL 2000 server.
> Please help. Thanks.
>
As you can log in with windows authentication then make sure that the
server is set to used mixed mode. Are you using Query Analyser to log
in? Try using the server's IP address instead of the server name,
'(local)' or '.'. You could also try removing the shared memory
setting on the protocol.
John