0
votes
2answers
181 views

Client connectivity to MSSQL

I'm wondering if there is a policy that can be pushed that defaults a client to always dynamically determine the port for connectivity. I'm dealing with a custom C# application that connects to a ...
1
vote
1answer
376 views

Error upgrading from SQL Server 2008 to SQL Server 2008 R2

I needed to restore a database (created in SQL Server 2008 R2 - version 10.50.1600) to a new DB in Server 2008 (version - 10.00.2531). I got the error - Restore failed for Server .... Additional info ...
-1
votes
1answer
54 views

SQL Server 2008 R2 remote connection

I am having problems making my ms sql server 2008 take remote connections, local workes fine. I have enabled the TCP/IP and the server browser server in the sql server config I have opened the ...
0
votes
2answers
58 views

Can not create a linked server between SQL Server 2008 on a desktop and my laptop

I'm having an issue getting the linked server to connect between a desktop and my laptop. Both have SQL server 2008 and the link is coming from the desktop to my laptop. Also, both computers have ...
3
votes
3answers
2k views

How do I encrypt SQL Server traffic with IPSEC?

I've found all sorts of documentation on what IPSEC is and how to (in very non-specific ways) configure it, but I can't seem to configure a Windows Firewall With Advanced Security rule that both A) ...
-1
votes
1answer
213 views

Fresh install of SQLSERVER 2008 r2 Express, what's my server name? [closed]

See this image: http://imgur.com/WxAQc It's a fresh Win7 install, fresh 2008 r2 install. For the life of me I can't work out what to enter as server name, I've tried: TOM Localhost SQLEXPRESS ...
1
vote
2answers
105 views

using win7 pc instead of windows 2003 server

Simple question, in terms of hosting an Asp.net-mvc/SQL Server 2008 R2 Express based app, will a powerful Windows 7 PC do? I just wonder if there is anything I'm missing here, being an App Dev and not ...
3
votes
1answer
3k views

KB2494088 Always Fails : How to get it to install (or stop trying to)?

I have a problem where KB2494088 (a SQL Server 2008 R2 patch) continually fails to install when I reboot my system. Downloading the manual patch and trying to apply it says: The SQL Server patch ...
0
votes
1answer
8k views

Installing SQL Server 2008 R2 32bit on 64bit : WoW64 error

It looks like it's possible for 2008 SP1: previous question. But what about current newer 2008 R2 version? We plan to use single 32bit Express edition package to install on every machine. However, ...
1
vote
2answers
3k views

SQL Server 2008 R2 on Windows 7 Starter?

I tried installing SQL Server 2008 R2 on my machine running Windows 7 starter but got an error: An error occurred during the installation of assembly ...