MarkW
Member
Registered: 19th Mar 04
Location: Orpington, Kent
User status: Offline
|
hopefully someone will know this; please remeber i have very little experience with sql!
ok i have a database called "production" now i need the default sa user to be able to access this from another program.
now sa is in "users" on the "master" database though not this one called production.
help please its driving me nuts!!
|
M4tt_Envoy
Member
Registered: 26th Feb 06
Location: Swindon
User status: Offline
|
2000 0r 2005?
if it 2000, open enterprise manager and the database and select the users option. then add user and select sa from the drop down
|
MarkW
Member
Registered: 19th Mar 04
Location: Orpington, Kent
User status: Offline
|
2000
and dont that it doesn't work lol
|
M4tt_Envoy
Member
Registered: 26th Feb 06
Location: Swindon
User status: Offline
|
who are you logged in as when your trying to do it? sa or WAU?
|
Samls
Member
Registered: 25th Jan 07
Location: Derby
User status: Offline
|
are you using mssql or mysql?
if ur using mssql get rid of it quickly 
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
quote:
Originally posted by Samls
are you using mssql or mysql?
if ur using mssql get rid of it quickly
Why?
|
Samls
Member
Registered: 25th Jan 07
Location: Derby
User status: Offline
|
mssql and your asking me why?
|
topshot_2k
Banned
Registered: 1st Dec 03
Location: Northampton Drives: Pug GTi-6
User status: Offline
|
he says it as he thinks taking piss out of anything MS is cool 
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
quote:
Originally posted by Samls
mssql and your asking me why?
Yes I am asking you why, do you have a clue what you are talking about?
|
Samls
Member
Registered: 25th Jan 07
Location: Derby
User status: Offline
|
first of all yes. If you want to take a look at my database driven work feel free to u2u me and ill show u.
Secondly. Why would any 1 run a web server on a windows based operating system? i.e. mssql
|
topshot_2k
Banned
Registered: 1st Dec 03
Location: Northampton Drives: Pug GTi-6
User status: Offline
|
what a joker
|
Samls
Member
Registered: 25th Jan 07
Location: Derby
User status: Offline
|
im a joker for trying to offer advice in an area ive got 5 years experience in!
|
topshot_2k
Banned
Registered: 1st Dec 03
Location: Northampton Drives: Pug GTi-6
User status: Offline
|
your a joker for thinking windows is crap at everything
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
quote:
Originally posted by Samls
im a joker for trying to offer advice in an area ive got 5 years experience in!
 You've been doing it since you were 12
I'm a final year computing student and software consultant, you are 17.
That is all.
|
--Dave--
Banned
Registered: 17th Feb 04
Location: Essssseeeeex Drives: Black Supra TT
User status: Offline
|
pwned.
|
Samls
Member
Registered: 25th Jan 07
Location: Derby
User status: Offline
|
ye ive been using html since i was 12 moving on to php and mysql. I now work as a full time coder not a student!!! I dont windows everything is crap, i have my opinion on windows doing certain things and in certain areas it is crap!
|
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
|
quote:
Originally posted by Samls
are you using mssql or mysql?
if ur using mssql get rid of it quickly
Anyone who knows what they are talking about knows this guy clearly doesn't.
Twat
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
quote:
Originally posted by Samls
Why would any 1 run a web server on a windows based operating system?
.NET development environment, NT domain authentication, configuration via Remote Desktop, probably some other stuff...
|
MarkW
Member
Registered: 19th Mar 04
Location: Orpington, Kent
User status: Offline
|
nice argument, thanks for the advice guys though i have found the problem and it had nothing to do with SQL cheers anyway though 
|
