Wednesday, August 21, 2013

[MS SQL Server] SSRS Dataset Credentials

[MS SQL Server] SSRS Dataset Credentials

SSRS Dataset Credentials

Posted: 20 Aug 2013 06:06 AM PDT

We want to use Report Builder to allow people to create ad-hoc reports from a database. I created an account in SSMS and gave it datareader role to a particular database. I then created a data source in Reporting Services and chose 'credentials stored securely in the report server'. Within Report Builder that data source is now available. Here is the issue – we never, ever want the end user to know what the username/password is/are. However, in order to create a dataset using the shared data source, you have to input the username/password. I am fairly new to using SSRS so I am really hoping that there is a way to embed the login credentials somehow so the end-user will never see them and will never be asked to supply them.

SQL database graceful shutdown that is not seen as unexpected

Posted: 21 Aug 2013 12:48 AM PDT

We have SQL server 2008 R2 on a Windows Server 2008 R2 Standard machine. We shut the database down every night to get a cold backup - the service is set to restart after an Unexpected shutdown. Our problem is the database is restarting before we can get a cold copy of the files (about 15 minutes) & whatever database is copying when SQL restarts fails to start up because the file is locked. My question is there a way to do a graceful shutdown so the operating system can tell the difference that this is NOT unexpected? We are using a .bat with Net STOP agent & net stop SQL SERVER.The obvious answer would be to take the restart off the service - but we do like that option in case of a shutdown of the database other than for the backup. Thank you for any help.

Merge replication between two different databases?

Posted: 20 Aug 2013 11:39 PM PDT

It's possible I may need to implement merge replication of one table sometime in the near future. My question is, can you merge replicate between two different databases?Say on server1, we have a database called database01, with a table 'users01', and on server02 the database is database666 and table 666users01.Could we replicate between them?Jason

Datatype conversion

Posted: 20 Aug 2013 09:58 AM PDT

How do i convert nvarchar datatype column to float? The only problem is nvarchar column has non-numeric values like names.

SQL Server log backup fails sometimes

Posted: 20 Aug 2013 12:21 PM PDT

We are running SQL Server 2008 R2 SP1. There is a scheduled transaction log backup using SQL Server maintenance job that runs at a certain time of the day. The job runs fine on few days and fails few days and there is no specific pattern. I changed the schedule to run every 5 minutes and the log backups were fine for the first 3 attempts and started failing randomly.-- operating system error 53(the network path was not found.) --I am not sure why it fails few times and runs fine the rest of the times. The backups are going directly to SAN storage and use UNC path - e.g. \\vnvx\SQL_backups\SQL Server errorlog has the following messages:Backup Error: 3041, Severity: 16, State: 1.Error: 18204, Severity: 16, State: 1. BackupDiskFile::CreateMedia: Backup device 'N:\Backups\Userdatabases\Database\db _backup_200911111511.bak' failed to create. Operating system error 53(the network path was not found.) If it fails on a regular basis I could have checked permissions, SQL Server agent start up ID etc. However it fails few times and runs successfully few times. The job is set to run with 1 retry after 2 minutes and sometimes the 2nd attempt goes through.Please help. Thanks in advance.

client was unable to reuse a session?

Posted: 20 Aug 2013 04:33 PM PDT

HiI am received email alert frequently as below error messages.[code="sql"]DESCRIPTION: The client was unable to reuse a session with SPID 119, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.[/code]Microsoft Fix that issues http://support.microsoft.com/kb/2543687 by updating latest service pack3 & CU1 of SP3.Currently - SQL Server 2008 standard edition with SP1Can we update SP3 and CU1 for resolve that issues? please suggesion me..Thanksananda
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog