Here is the problem I am having. We have a SQL database on the server. Through VB app I connect to the server (OLE DB) and can create new users for the server (and users database) by running sp_addlogin. It all happens programaticaly in VB.
Now we copied the data to another server. Create a new user login with all the same permissions as on the first server. However now when I connect with this login I can't create any new users. I compared everything on the old server and new server and didn't find anything different. What should I look at? Any ideas? Appriciate any help.
Now we copied the data to another server. Create a new user login with all the same permissions as on the first server. However now when I connect with this login I can't create any new users. I compared everything on the old server and new server and didn't find anything different. What should I look at? Any ideas? Appriciate any help.