Super User
Super User

Questions tagged [sql-server-2008-r2]

31 questions
23
votes
4 answers

Floating or vertical results pane in SQL Server Management Studio

I have a multi monitor configuration and would like to be able to have my query editor on one monitor and the results pane on another. Can this be achieved? Either by having the results pane vertically attached to the query editor instead of…
Shevek
  • 16,738
10
votes
4 answers

Cannot connect to SQL Server from Excel 2007

I am trying to connect to Microsoft SQL Server 2008 R2 from Excel 2007. When it tries to connect I get the error: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. Steps to Reproduce On the Data tab, in the Get External Data…
Ian Boyd
  • 23,066
7
votes
1 answer

Error Code 1608 during SQL Server install?

I get the following error early during my SQL Server 2008 R2 installation: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'. Error code: 1608. How can I proceed with…
lance
  • 1,957
5
votes
2 answers

Event log warning Registry setting specifying configuration file does not exist

Microsoft SSIS Service: Registry setting specifying configuration file does not exist. Attempting to load default config file. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. this is my…
mbrc
  • 151
4
votes
3 answers

Installing SQL Server 2008 R2 on Windows 8 (Enterprise Evaluation)

When I Try to install SQL Server 2008 R2 on Windows 8 (Enterprise Evaluation), a compatibility warning massage is displayed, Tried Get help online option but it is says No solution found, but setup starts when I select Run the program without…
Nalaka526
  • 1,624
3
votes
1 answer

Install sql server management studio API only

I have already installed sql server 2008 R2 , but now i need to install sql server management studio also ( i mean just that API ony ) is it possible to install only this instead of uninstall sql server 2008 R2 and Re-install sql server managemant…
Arun Cm
  • 31
3
votes
2 answers

Installation of Microsoft SQL Server 2008 R2 Developer Edition fails with unknown property

Installing MS SQL Server 2008 Developer edition on a Vista Ultimate 64 Bit machine keeps returning the following error message: SQL Server Setup failure SQL Server Setup has encountered the following error: Unknown property. I've tried the…
Yustme
  • 145
  • 8
2
votes
1 answer

Microsoft SQL Server Management Studio sometimes Sees but other times Fails to See

My computer has the following Software involved. Microsoft Windows 7 Microsoft SQL Server 2008 R2 Microsoft SQL Server Management Studio Moreover, I have the following Drive partitions: C: drive D: drive E: drive Therefore, when I created the…
user1338998
  • 259
  • 1
  • 9
2
votes
1 answer

The Login is from an untrusted domain - domain setup with computer level login

I have a SQL Server 2008 R2 database I'm attempting to connect to using ADO.NET using integrated security in the connection string. The database resides on a 64-bit Windows Server 2003 machine. The client is a 64-bit Windows 7 Enterprise machine. …
Peter Smith
2
votes
0 answers

Why is my Access 2010 ADP not filtering its SQL statements when connected to MSSQL 2008 R2?

I use MSSQL MS for most administrative tasks on SQL Server 2008 R2 databases, but I find using Access (via an ADP, not linked tables) to view and edit raw table data to be much more efficient. (This is for sysadmin use only, of course, user access…
richardtallent
  • 1,322
2
votes
1 answer

What is the safest way to set up SQL Server for remote access?

I'd like to be able to make my dev database server accessible over the internet. I and half a dozen dev applications will be the only users. I have a hosting account that includes SQL Server, but I prefer to keep this for staging and production…
immutabl
  • 1,846
  • 6
  • 23
  • 33
2
votes
0 answers

Jira does not wait SQL Server to start

I am using Jira 3.1 for task tracking. It works over SQL Server 2008 R2. Recently I tried to use Jira as a service rather than running it from a command line. I have installed the service and put dependency from SQL Server service. The problem,…
Alex
  • 241
2
votes
3 answers

SQL Server 2008 R2 - Cannot Connect Remotely (Error 1326)

For some reason, now I cannot connect to my SQL Server 2008 server remotely. I can login locally, but I get Error 1326 that I cannot connect to the server. SQL Browser is running, firewall ports were opened (I used the script given in Microsoft…
Brian Mains
  • 209
2
votes
2 answers

Windows 7 Error Installing SQL Server 2008 R2 MSIGetProductInfo fails for {90120000-00A4-0409-0000-0000000FF1CE}

I downloaded SQL Server 2008 R2 Express and during the installation, I got the following cryptic error: SQL Server Setup has encountered the following error: MSIGetProductInfo failed to retrieve the ProductVersion for package with Product Code =…
Noah
  • 2,657
2
votes
1 answer

SQL Server 2008 R2 - Unable to uninstall

This happens if I try to uninstall it or even repair it. The setup stops working at the end. Any help would be much appreciated.
Brave Newbie
  • 368
1
2 3