Chapter 16 on Page 614

FittyFrank · November 9th, 2015, 01:14 AM

Quote:

Originally Posted by Imar

>> just need to move the database out of localDB and into SQL Server 2014 and hopefully figure it out.

Check Appendix B; it has all the details on how to make this work.

Imar

I couldn't get the .mdf file from the source code files attach to my 2014 SQL Server Express (only to local db), so I just recreated the database which was quick (chapter 12 and 14 to create the four tables). The hard part for me was the connection string. The "Data Source" part is equal to just the name of your server, you do not need \SQLEXPRESS or anything like that after it like with LocalDB. Like Imar said, Appendix B has good info to help out on this process.

Now to try and configure the roles again...

Imar · November 9th, 2015, 04:12 AM

>> you do not need \SQLEXPRESS or anything like that after it like with LocalDB.

That really depends on the target server. Indeed often you'll encounter an unnamed instance that you can address with the machine's name or just a . However, it's also possible to install the full versions of SQL Server as named instances on which case the name (the part after .\) is something that an administrator determines during installation.

Imar

FittyFrank · November 13th, 2015, 12:02 AM

Update: I have the roles information from the providers package saved on my server rather than localdb. After doing this, I was able to successful connect to and use WSAT.

Thanks for all your help Imar!

Imar · November 13th, 2015, 03:18 AM

You're welcome. Glad it's all working now.

Imar