Re: Create Database
From: Usman (jathol@hotmail.com)
Date: 03/19/03
- Next message: Lior: "Service Pack 3 applied - and problems!"
- Previous message: Neil Pike: "Re: IE hangs up when SQL2000 service starts"
- In reply to: Roy: "Create Database"
- Next in thread: SriSamp: "Re: Create Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Usman" <jathol@hotmail.com> Date: Tue, 18 Mar 2003 16:25:54 -0800
well.
chaeck if you are using Windows authentication...
go for SQL
thanks
Usman
"Roy" <rx46@hotmail.com> wrote in message
news:0c6a01c2ecf7$be0e7150$a301280a@phx.gbl...
> I have installed sql server 2000 on two systems.
> I add my domain account to the system administrion group
> on the second system.
> I add a new sql server registration on the 1st system so
> that it point to the sql server on the 2nd one.
> I launch the Query Analizer and connect to the sql server
> on the 2nd system by using the previous account. Run a
> script to CREATE DATABASE. It fails by telling me that
> there is a permission problem.
> If I run the script on the query analyzer of the 2nd
> system directly, it is successful. So the script itself
> is correct.
> Why can't I create the db on the 2nd system from the 1st
> system by connecting the query analyzer in this case?
- Next message: Lior: "Service Pack 3 applied - and problems!"
- Previous message: Neil Pike: "Re: IE hangs up when SQL2000 service starts"
- In reply to: Roy: "Create Database"
- Next in thread: SriSamp: "Re: Create Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
