Showing posts with label backed. Show all posts
Showing posts with label backed. Show all posts

Friday, March 9, 2012

Problems with debugging remotely SQLCLR stored procedures?

Hello,

my username is se\levalencia, I had before the database on my machine, but as now we have a server I backed up the database and restored on the server, it seems that it has the sames logins and security users,

Its strange because the user dbo is assigned the user se\levalencia on the server, and I cant alter the user dbo.

The user dbo should be the login sa? I am in big trouble with this, beacuase I cant debug my sql clr stored procedure.

T-Sql execution ended without debugging. You may have not have sufficient permissions to debug.

I am using a connection with windows authentication, so it means that its sending tha tokes as se\levalencia to the server.

Please feel free to ask for more information about it. Thanks

More strange yet, I just changed the connection and put SA as the user which executes the sql clr stored procedure, I got the same problem, its supposed to be a super user.

|||

You would need to add se\levalencia as a member of sysadmin role on the server. For debugging T-SQL as well as SQLCLR the debugger needs to run under an account that is a member of sysadmin role on SQL Server.

Thanks,

-Vineet.

Problems with debugging remotely SQLCLR stored procedures?

Hello,

my username is se\levalencia, I had before the database on my machine, but as now we have a server I backed up the database and restored on the server, it seems that it has the sames logins and security users,

Its strange because the user dbo is assigned the user se\levalencia on the server, and I cant alter the user dbo.

The user dbo should be the login sa? I am in big trouble with this, beacuase I cant debug my sql clr stored procedure.

T-Sql execution ended without debugging. You may have not have sufficient permissions to debug.

I am using a connection with windows authentication, so it means that its sending tha tokes as se\levalencia to the server.

Please feel free to ask for more information about it. Thanks

More strange yet, I just changed the connection and put SA as the user which executes the sql clr stored procedure, I got the same problem, its supposed to be a super user.

|||

You would need to add se\levalencia as a member of sysadmin role on the server. For debugging T-SQL as well as SQLCLR the debugger needs to run under an account that is a member of sysadmin role on SQL Server.

Thanks,

-Vineet.

Monday, February 20, 2012

Problems when trying to recuperate bank

When I try to recuperate a bank he/she appears the following message:
The database you are attempting to restore was backed up under a dirrerent
Unicode locale ID (1046) or Unicode
comparison style (196609) than the Unicode locale ID (1033) or Unicode
comparison style (196609) currently running
on this server.
Backup ou restore operation terminating abnormally.
does anybody can me to help?Are you restoring a SQL 7 database?... In SQL 7 you can only restore a
database to a server which has the same character set and sort order as the
database... Sounds like the character sets don't match... However you could
restore it to a SQL 2k server, since each database can have its own char set
sort order..
For SQL 7 you will have to install a server with a matching char set sort
order, then you may restore the db.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#EyUMLDYDHA.4040@.tk2msftngp13.phx.gbl...
>
> When I try to recuperate a bank he/she appears the following message:
> The database you are attempting to restore was backed up under a dirrerent
> Unicode locale ID (1046) or Unicode
> comparison style (196609) than the Unicode locale ID (1033) or Unicode
> comparison style (196609) currently running
> on this server.
> Backup ou restore operation terminating abnormally.
>
> does anybody can me to help?
>