Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Getting a "not a valid login" error when installing SQL 2008 R2 Express Expand / Collapse
Posted Thursday, November 7, 2013 10:29 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 982, Visits: 1,710
I've got a SQL script to create a database and populate it with the necessary tables, views and stored procedures. I've also added what I thought would be the necessary SQL code to create 2 new logins. But whenever I run this on a machine, I always get this error (I'll show just one error, but it's the same for the other login):

'intake' is not a valid login or you do not have permission.

Now, as it so happens, I always create these installations with the logged in user having administrator rights on that instance of SQL 2008 R2 Express, so I don't believe they don't have enough permissions. I'm doing this on Windows 7 Professional machines.

I'm beginning to wonder, would I be better off writing a SQL script to create the 2 logins, run that first, and then run the SQL script to create the database?

Kindest Regards,

Connect with me on LinkedIn.
Post #1512372
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse