Tuesday, July 16, 2013

[SQL 2012] Localisation and SQL 2012 deployment

[SQL 2012] Localisation and SQL 2012 deployment

Localisation and SQL 2012 deployment

Posted: 16 Jul 2013 02:45 AM PDT

Hi guys,we are deploying an application to several locations from the UK, one of these is Moscow.The application is dependant on SQL express 2012, so as part of the installer we have a silent install of SQL 2012 using something like the following:SQLEXPR32_x86_ENU.exe /qs /IACCEPTSQLSERVERLICENSETERMS /INSTANCENAME=xxxxxxx /SQLSYSADMINACCOUNTS=\"BUILTIN\\ADMINISTRATORS\" /ACTION=Install /FEATURES=SQLEngine /SECURITYMODE=SQL /SAPWD=xxxxxxxx";When we installed the app locally, the sql install works perfectly, but when we install it in Moscow, it complains about BUILTIN\\ADMINISTRATORS as it not in Russian.Has anyone dealt with language variants for security groups on the install?Many thanks for any guidance!Peter

USE Database

Posted: 15 Jul 2013 10:50 PM PDT

Hi Team,Am having two datbases in one instance, whenever i execute any scripts, i'll use "USE DATABASE" and execute the scripts,Is there any way to mention instance name, instead of Database name.Eg: USE INSTANCEGOUSE DATABASEGOEXEC Store_spoc..Please Suggest...

Report URLs may use only http://, https://, ftp://, file:// error

Posted: 15 Jul 2013 08:12 PM PDT

Friend, I am trying to generate a report in BIDS. The report is generated from SQL Server 2012 through a Stored Procedure. We are in the process of defining Indexes for the table used to generated the report. There are thousands of records in the table. The report is getting generated after 2 mins in BIDS. The report has 3 pages. I am getting an error while trying to navigate to the second page. Has anybody come across this error. Is this error due to some timeout issue. I am attaching the screenshot. [img]C:\Users\154302\Desktop\Error.JPEG[/img]I executed the Stored Procedure in SSMS and it is executing successfully in 2 mins. I cannot find the reason for this issue. Any help would be appreciated.

Best Practive Network Adapter Configuration for AlwaysOn

Posted: 15 Jul 2013 03:29 PM PDT

Hi,Just wondering if anyone would be able to give any advice here. We are currently setting up AlwaysOn in our new SQL2012 environment and our sys admin team want to have 2 network adapters in each node of 2 node cluster - one adapter would be for regular OLTP traffic and the other adapter would be for AlwaysOn replication traffic.I have been asked to find out what the best practice is for network adapter configuration with AlwaysOn but haven't really been able to find anything online,Thanks in advance,JK
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog