Connection

Hi I'm George and I have a problem wich I can't solve:
when I install a CMS wich uses MSDE il get the Message this is not a trusted
SQLConnection..blablabla...
What can I do ? Please help me.
George wrote:
> Hi I'm George and I have a problem wich I can't solve:
> when I install a CMS wich uses MSDE il get the Message this is not a
> trusted SQLConnection..blablabla...
> What can I do ? Please help me.
You can add your local Windows login or Domain Login to SQL Server. To
do this, run SQL Enterprise Manager and add a new login and map it to
the domain/Windows login (under the Security node).
David Gugick
Quest Software
www.imceda.com
www.quest.com

Connection

Hi I'm George and I have a problem wich I can't solve:
when I install a CMS wich uses MSDE il get the Message this is not a trusted
SQLConnection..blablabla...
What can I do ' Please help me.George wrote:
> Hi I'm George and I have a problem wich I can't solve:
> when I install a CMS wich uses MSDE il get the Message this is not a
> trusted SQLConnection..blablabla...
> What can I do ' Please help me.
You can add your local Windows login or Domain Login to SQL Server. To
do this, run SQL Enterprise Manager and add a new login and map it to
the domain/Windows login (under the Security node).
David Gugick
Quest Software
www.imceda.com
www.quest.com

Connection

Hi I'm George and I have a problem wich I can't solve:
when I install a CMS wich uses MSDE il get the Message this is not a trusted
SQLConnection..blablabla...
What can I do ' Please help me.George wrote:
> Hi I'm George and I have a problem wich I can't solve:
> when I install a CMS wich uses MSDE il get the Message this is not a
> trusted SQLConnection..blablabla...
> What can I do ' Please help me.
You can add your local Windows login or Domain Login to SQL Server. To
do this, run SQL Enterprise Manager and add a new login and map it to
the domain/Windows login (under the Security node).
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Connectio to Remote SQL Server from another SQL Server Stored Proc

Hi,
I have a problem with a conection to Remote SQL Server Database wich have a
blank space in databese name.
Ex.
"Production ED"
I Can`t change the name of this data base.
I Need to connect this database with a Stored Procedure in another Server.
Both Databases are SQL Server 2000 Ent. Ed.
Would it help if you put the name in brackets?
[Production ED]
so you could do something like...
select * from
[Production ED].dbo.ProcedureName
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Esteban" <Esteban@.discussions.microsoft.com> wrote in message
news:7CA8D942-0B44-434C-BD4D-34E4231DC7E8@.microsoft.com...
> Hi,
> I have a problem with a conection to Remote SQL Server Database wich have
> a
> blank space in databese name.
> Ex.
> "Production ED"
> I Can`t change the name of this data base.
> I Need to connect this database with a Stored Procedure in another Server.
> Both Databases are SQL Server 2000 Ent. Ed.

Connectio to Remote SQL Server from another SQL Server Stored Proc

Hi,
I have a problem with a conection to Remote SQL Server Database wich have a
blank space in databese name.
Ex.
"Production ED"
I Can`t change the name of this data base.
I Need to connect this database with a Stored Procedure in another Server.
Both Databases are SQL Server 2000 Ent. Ed.Would it help if you put the name in brackets?
[Production ED]
so you could do something like...
select * from
[Production ED].dbo.ProcedureName
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Esteban" <Esteban@.discussions.microsoft.com> wrote in message
news:7CA8D942-0B44-434C-BD4D-34E4231DC7E8@.microsoft.com...
> Hi,
> I have a problem with a conection to Remote SQL Server Database wich have
> a
> blank space in databese name.
> Ex.
> "Production ED"
> I Can`t change the name of this data base.
> I Need to connect this database with a Stored Procedure in another Server.
> Both Databases are SQL Server 2000 Ent. Ed.