Setup MSSQL Database Locally

Posted on 11/08/2008 12:55:16

Hi Im trying to setup my local DW solution to work with an mssqldatabase for the first time. I've always used the Access databases but I really want to get away from that. I have restored the default empty data file both to my local mssql Express and a remote mssql express I have installed on another server. The solution I set up works fine with the ms_access databases but in my globalsettings.aspx, when i try to connect I just get a plain blank page, no errormessage no nothing.

my setup looks like this:

<Database>
     <Password></Password>
      <Type>ms_sql</Type>
      <UserName></UserName>
      <Database></Database>
      <SQLServer></SQLServer>
      <DWWebIP>
      </DWWebIP>
      <SQLServer2>
      </SQLServer2>
      <Database2>
      </Database2>
      <UserName2>
      </UserName2>
      <Password2>
      </Password2>
      <IntegratedSecurity></IntegratedSecurity>
      <ConnectionString>Server=******\SQLEXPRESS;Database=DW_Default;User ID=******;Password=********</ConnectionString>
      <ConnectionString2></ConnectionString2>
    </Database>

Am I missing something or is the problem something else?

- Sune

Replies

Posted on 11/08/2008 17:00:43

Fillout something like this:

<Password>myPassword</Password>
      <Type>ms_sql</Type>
      <UserName>myUsername</UserName>
      <Database>myDatabaseOnTheServer</Database>
      <SQLServer>127.0.0.1</SQLServer>

u should not need to change anything else in the globalsettings.aspx file

Posted on 12/08/2008 10:26:15

if you are using SQL 2005 Express Edition you can use:

<SQLServer>./SQLEXPRESS</SQLServer>

remember to set the SQL 2k5 Express to accespt SQL-Type Authentication and add a login User using SQL Authentication.

Posted on 12/08/2008 10:31:50

Thanks for the Replies.

I got it to work now.

It appears the error was, that I called the server with:

***.***.***.\SQLEXPRESS When I was just supposed to call the ip alone ***.***.***.

- Sune

You must be logged in to post in the forum

Developer forum

Setup MSSQL Database Locally

Replies