Post reply

connect Database server

  • January 28, 2008 at 11:11 pm

    #181275

    Hi All,

    How to connect Database server(local) through Query?

    ---

  • January 28, 2008 at 11:29 pm

    #772730

    If you're on the machine that has SQL Server on, and there's a default instance, try one of the following:

    sqlcmd /E

    for integrated security, or

    sqlcmd /Uusername /Ppassword

    for SQL Server security. If there's a named instance you want to connect to, add

    /S./instancename

    Hope this helps - sqlcmd /? will give you all the options.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • March 11, 2010 at 4:53 pm

    #1132392

    Hi, I am new to SSRS and I am using 2005 version.

    http://www.sqlservercentral.com/articles/Development/2945/

    I tried the solution to use dynamic connection string. I followed the instrunctions as stated and the report works fine when I hard code the server and database. But once I switch it (to use parameters for the server and database) and deploy, it does not run.

    I am using a stored proc to retrieve the data for the report.

    ="Data Source=" & Parameters!Server.Value & ";Initial Catalog=" & Parameters!Database.Value

    I get the following error...

    An error has occurred during report processing. (rsProcessingAborted)

    Error during processing of the ConnectString expression of datasource ‘RptData’. (rsDataSourceConnectStringProcessingError)

    Can someone help me out?

  • March 12, 2010 at 8:08 am

    #1132722

    Hi. I figured out the problem and it is working now.

    The server and database parameters must come before any other parameter the report is expecting.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply