When I tried to add a new login to the server and after assigning DB Roles,
I am getting the error message that the role has been already added to the user. I think this username has already been in the system earlier. It is in the sysuser table. I tried to delete the roles to which this user has permissions. But still I am getting this error. I am not sure where else it is stored. How can I delete this username completely from all Databases and reassign this userid in the server.
Please advise.You're trying to modify system tables...hmmmmmmmmm
What other type of work do you do?
Look at system stored procs sp_dropuser and sp_droplogin|||I am not modifying the system tables. I am trying to add a new user.
But it is not letting me do that as this user already exists in the sysuser table. I executed sp_dropuser 'test' and sp_droplogin 'test'. But still getting the same error when I tried to add this userid and assigned DB roles(I am doing for all 4 DBs at a time).
Thanks
Radhika
Showing posts with label roles. Show all posts
Showing posts with label roles. Show all posts
Monday, March 12, 2012
Wednesday, February 15, 2012
'Error Message
Hi All
I have the 3 servers, A, B & C. A is the publisher, B is the distributor and
C is the subscriber. I have enabled these servers with their roles. I created
a publication which i try to do a transactional replication and i get an
error like this:
'Error Message:
The process could not create file '\\B\SNAPSHOT\unc'.
Error Details:
The network path was not found.
(Source: (OS); Error number: 53)
I don't know what to do and i need some help. Thank you in advance.
Mitty,
can you log on to the publisher as the sql server agent's login and see if
you can browse to the distribution working folder (\\B\SNAPSHOT\). If you
can, see if you can create a file there. This'll test the existance of the
share, your rights to add a file and also see if there is enough space
there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
I have the 3 servers, A, B & C. A is the publisher, B is the distributor and
C is the subscriber. I have enabled these servers with their roles. I created
a publication which i try to do a transactional replication and i get an
error like this:
'Error Message:
The process could not create file '\\B\SNAPSHOT\unc'.
Error Details:
The network path was not found.
(Source: (OS); Error number: 53)
I don't know what to do and i need some help. Thank you in advance.
Mitty,
can you log on to the publisher as the sql server agent's login and see if
you can browse to the distribution working folder (\\B\SNAPSHOT\). If you
can, see if you can create a file there. This'll test the existance of the
share, your rights to add a file and also see if there is enough space
there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Posts (Atom)