ok, a sql login is different to a windows login create a sql login in your enterprise manager.
give it a sql password. allocate it to a database and give it read permissions (ie Permit in Database Role: db_datareader) now use these details as the connection details for your DSN. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 25 February 2003 16:52 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL 2K DSN > > > Ok maybe I wasn't as clever as I thought ..... > > I have created a new login. > > <General Tab> > > Selected the user from the windows users on the machine (me) > Windows Authentication > Domain MARGE > Grant Access > Default Database Northwind > Language British English > > <Server Roles> > System Administrator > > <Database Access> > All databases ticked > > Database roles for northwind > db_owner > > Now I can't connect :-( > > All I want is to give my account administrator rights over > the SQL server. > Seeing as I 'll probably be the one looking after it if I > ever get it going > ..... > > Regards - Paul > > > > > ************************************************************* > This email and any files transmitted with it are confidential > and intended solely for the use of the individual or entity > to whom they are addressed. If you have received this email > in error please notify [EMAIL PROTECTED] > > The views expressed within this email are those of the > individual, and not necessarily those of the organisation > ************************************************************* > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
