Win2K Adv. Server/SQL Server 2000 set up 
Author Message
 Win2K Adv. Server/SQL Server 2000 set up

Hi

Trying for the first time in my life to set up a server with SQL Server 2000
on it, so that I can connect from another computer on a network.

The set up is SQL Server is installed on a Win 2k Advanced Server, and I
want to connect through TCP/IP from a Win 2k Pro notebook.

Service Manager on the notebook finds the server and SQL Server fine. I can
start and stop SQL Server without a problem.

But when I try to connect from the notebook to the server using ISQL/w, I
get Msg 18452 Unable to connect to server w2kas-server\devlopment:
Server:Login failed for ser '(null)'. Reason: Not associated with a trusted
SQL Server connection"

I assume I need to let my server, and SQL Server on the server know about
the notebook so that Windows Authentication works. But the big question I
cant find the answer to is "how"

Any help greatly appreciated

Thanks

Robin



Sat, 22 May 2004 04:19:16 GMT
 Win2K Adv. Server/SQL Server 2000 set up

It sounds like you are using integrated security. You'll need to create an
NT login or group login account on SQL Server (security/logins). Assign
appropriate permissions and database access to the id (or group).

Steve

Quote:
> Hi

> Trying for the first time in my life to set up a server with SQL Server
2000
> on it, so that I can connect from another computer on a network.

> The set up is SQL Server is installed on a Win 2k Advanced Server, and I
> want to connect through TCP/IP from a Win 2k Pro notebook.

> Service Manager on the notebook finds the server and SQL Server fine. I
can
> start and stop SQL Server without a problem.

> But when I try to connect from the notebook to the server using ISQL/w, I
> get Msg 18452 Unable to connect to server w2kas-server\devlopment:
> Server:Login failed for ser '(null)'. Reason: Not associated with a
trusted
> SQL Server connection"

> I assume I need to let my server, and SQL Server on the server know about
> the notebook so that Windows Authentication works. But the big question I
> cant find the answer to is "how"

> Any help greatly appreciated

> Thanks

> Robin



Sat, 22 May 2004 05:02:57 GMT
 Win2K Adv. Server/SQL Server 2000 set up
Hi

Sort of gathered that bit (but thanks for confirming). Where the problem
lies is how do I get my notebook listed in the NT groups logins.

Mmmm. I think this might be an O/S question rather than a SQL Server
question....

Thanks tho


Quote:
> It sounds like you are using integrated security. You'll need to create an
> NT login or group login account on SQL Server (security/logins). Assign
> appropriate permissions and database access to the id (or group).

> Steve


> > Hi

> > Trying for the first time in my life to set up a server with SQL Server
> 2000
> > on it, so that I can connect from another computer on a network.

> > The set up is SQL Server is installed on a Win 2k Advanced Server, and I
> > want to connect through TCP/IP from a Win 2k Pro notebook.

> > Service Manager on the notebook finds the server and SQL Server fine. I
> can
> > start and stop SQL Server without a problem.

> > But when I try to connect from the notebook to the server using ISQL/w,
I
> > get Msg 18452 Unable to connect to server w2kas-server\devlopment:
> > Server:Login failed for ser '(null)'. Reason: Not associated with a
> trusted
> > SQL Server connection"

> > I assume I need to let my server, and SQL Server on the server know
about
> > the notebook so that Windows Authentication works. But the big question
I
> > cant find the answer to is "how"

> > Any help greatly appreciated

> > Thanks

> > Robin



Sat, 22 May 2004 06:24:59 GMT
 Win2K Adv. Server/SQL Server 2000 set up
It's actually done by user account, not machine account -- do check with
your NT Administrator - they should be able to help you.

Steve

Quote:
> Hi

> Sort of gathered that bit (but thanks for confirming). Where the problem
> lies is how do I get my notebook listed in the NT groups logins.

> Mmmm. I think this might be an O/S question rather than a SQL Server
> question....

> Thanks tho



> > It sounds like you are using integrated security. You'll need to create
an
> > NT login or group login account on SQL Server (security/logins). Assign
> > appropriate permissions and database access to the id (or group).

> > Steve


> > > Hi

> > > Trying for the first time in my life to set up a server with SQL
Server
> > 2000
> > > on it, so that I can connect from another computer on a network.

> > > The set up is SQL Server is installed on a Win 2k Advanced Server, and
I
> > > want to connect through TCP/IP from a Win 2k Pro notebook.

> > > Service Manager on the notebook finds the server and SQL Server fine.
I
> > can
> > > start and stop SQL Server without a problem.

> > > But when I try to connect from the notebook to the server using
ISQL/w,
> I
> > > get Msg 18452 Unable to connect to server w2kas-server\devlopment:
> > > Server:Login failed for ser '(null)'. Reason: Not associated with a
> > trusted
> > > SQL Server connection"

> > > I assume I need to let my server, and SQL Server on the server know
> about
> > > the notebook so that Windows Authentication works. But the big
question
> I
> > > cant find the answer to is "how"

> > > Any help greatly appreciated

> > > Thanks

> > > Robin



Sat, 22 May 2004 08:09:07 GMT
 Win2K Adv. Server/SQL Server 2000 set up
Thanks

But I found out it was my Active Directory not set up correctly

Thanks

Robin


Quote:
> It's actually done by user account, not machine account -- do check with
> your NT Administrator - they should be able to help you.

> Steve


> > Hi

> > Sort of gathered that bit (but thanks for confirming). Where the problem
> > lies is how do I get my notebook listed in the NT groups logins.

> > Mmmm. I think this might be an O/S question rather than a SQL Server
> > question....

> > Thanks tho



> > > It sounds like you are using integrated security. You'll need to
create
> an
> > > NT login or group login account on SQL Server (security/logins).
Assign
> > > appropriate permissions and database access to the id (or group).

> > > Steve


> > > > Hi

> > > > Trying for the first time in my life to set up a server with SQL
> Server
> > > 2000
> > > > on it, so that I can connect from another computer on a network.

> > > > The set up is SQL Server is installed on a Win 2k Advanced Server,
and
> I
> > > > want to connect through TCP/IP from a Win 2k Pro notebook.

> > > > Service Manager on the notebook finds the server and SQL Server
fine.
> I
> > > can
> > > > start and stop SQL Server without a problem.

> > > > But when I try to connect from the notebook to the server using
> ISQL/w,
> > I
> > > > get Msg 18452 Unable to connect to server w2kas-server\devlopment:
> > > > Server:Login failed for ser '(null)'. Reason: Not associated with a
> > > trusted
> > > > SQL Server connection"

> > > > I assume I need to let my server, and SQL Server on the server know
> > about
> > > > the notebook so that Windows Authentication works. But the big
> question
> > I
> > > > cant find the answer to is "how"

> > > > Any help greatly appreciated

> > > > Thanks

> > > > Robin



Mon, 24 May 2004 07:32:30 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. SQL 2000 Install on Win2K SP3 Adv. Server

2. SQL 2000 Unattended Install hangs (on WIN2K adv Server)

3. a couple of questions - win2k Adv server - SQL 2000 cluster - full text search

4. Win2k Adv. Server + Sql Server 7

5. SQL Server 6.5 on Windows 2000 Adv. Server

6. SQL Server 7/Win NT Vs SQL Server 2000/Win2K : multi-processors management

7. SQL Server 7/Win NT Vs SQL Server 2000/Win2K : multi-processors management

8. Replacing hardware on WIN2K Adv Servers w/ SQL 7.0 E

9. SQL 7 on Win2K Adv. Server

10. SQL 7 installation error on Win2k adv server

11. win2k advanced server+ sql server 2000 standard

12. SQL Server 2000 Install on Win2k Advanced Server cluster


 
Powered by phpBB® Forum Software