Questions tagged [sql-server-2008-r2]
The sql-server-2008-r2 tag has no usage guidance.
31
questions
0
votes
1
answer
1k
views
SQL Server 2012 repair/installation fails
We have a Windows 2012 R2 server and want to run MS SQL Server 2012.
It seems like someone attempted installation a while back but it is not installed properly since SQL Server does not show under ...
- 1
1
vote
2
answers
22k
views
Installing SQL Server 2008 R2 on Windows 10 64-bit
I am trying to install SQL Server 2008 R2 on a Windows 10 64-bit machine.
I get a message telling me that
This app might not be work correctly.
Microsoft Sql Server (2008 and 2008 R2) isn't ...
- 21
0
votes
0
answers
756
views
Why SQL Server 2008 Reporting Services keep crashing when connecting to remote database server instance?
Background
I successfully setting up a database for SQL Server Reporting Services in Windows Server 2008 R2 using Reporting Services Configuration Manager with "Create a new report server database" ...
- 200
0
votes
1
answer
1k
views
ODBC connection to Cisco UCCX
I followed this guide to successfully create an ODBC connection to UCCX, but using the 32bit driver. I need to use the 64bit driver and the GUI changed dramatically.
My 64 bit ODBC settings
Below is ...
- 103
1
vote
0
answers
56
views
Presenting relationship of rows in SQL Server
I have two tables named FORM and FORMACTION. The rows in FORM represent screens in a CRM system and FORMACTION represents which FORMs lead to which. e.g.
FORM
ID,NAME,LNAME
1,"CustomerD","Enter ...
- 263
2
votes
1
answer
303
views
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
...
- 263
0
votes
2
answers
17k
views
What characters are allowed in in column (nvarchar 50) of MSSQL Server 2008?
I have a column in MSSQL which is nvarchar(50) in which I enter passwords for users.
I know that for example some special characters like $ % are allowed, but where do I see which list characters are ...
- 221
1
vote
1
answer
484
views
Access SQL Server from remote location
I have remote access enabled in SQL Server at my work network, which is on my "server". In the office, I have my desktop machine which I can use SQL Server Management Studio to access - no problems. I ...
0
votes
1
answer
21
views
Include job in bak to be activated on restore
I have a database with stored procedures and a maintenance job that runs some of the stored procedures nightly.
When I take a backup of the database, is there any way that I can include the job in ...
- 101
3
votes
1
answer
452
views
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 ...
- 31
2
votes
1
answer
3k
views
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 ...
Peter Smith
0
votes
2
answers
1k
views
How Do I Suppress SQL Server "Informational" Messages?
I've just installed SQL Server 2008 R2 Express for local development, and it's flooding the Application Event Log with a seemingly endless barrage of trivia and drivel ("SQL Server is now ready for ...
- 101
1
vote
0
answers
106
views
SQL Server Continues to Swap RAM After Using a Virtual Machine
I have a dev computer running Windows Server 2008 R2 Enterprise and SQL Server 2008 R2 Enterprise, with 8GB of RAM. As I write code and use the database, SQL Server will use more-and-more RAM (which ...
- 372
23
votes
4
answers
14k
views
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 ...
- 16.5k
4
votes
3
answers
33k
views
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 ...
- 1,524
2
votes
0
answers
523
views
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 ...
- 1,262
2
votes
1
answer
2k
views
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 ...
- 1,766
7
votes
1
answer
9k
views
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-...
- 1,837
3
votes
2
answers
1k
views
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 ...
- 145
1
vote
3
answers
11k
views
Microsoft SQL Server 2008 R2 Service Pack 1 (KB2528583) won't install
When I tried to update using Windows Update, it just "hangs" at the "Installing" step.
When I downloaded the patch and ran it myself, a console screen just pops up and disappears, and does nothing.
...
- 225
2
votes
0
answers
167
views
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 ...
- 241
1
vote
1
answer
54
views
How do I connect to a database without seeing all the other databases on the host?
I'm using Microsoft SQL Server Management Studio 2008 R2, I followed the instructions from my host and I'm successfully able to connect to my database, but I also happen to see all of the databases on ...
- 231
4
votes
2
answers
12k
views
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....
- 141
10
votes
4
answers
17k
views
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 ...
- 21.5k
1
vote
1
answer
697
views
Problem with remote connection to my sql server 2008 R2
I wanted to use my PC as SQL Server and connect to it from my notebook but I can't connect to it via public IP adress. Later i will need to create connection string to my c# application but for now I'...
- 111
2
votes
3
answers
19k
views
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 ...
- 189
1
vote
3
answers
5k
views
Can't install SSMS, complaining about Visual Studio 2008 when it's not even installed
So I just got a new windows 7 laptop, and i'm trying to get it all setup and ready for development. I installed Visual Studio 2010 professional and updated it to service pack 2. However, whenever I ...
- 351
2
votes
2
answers
3k
views
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 ...
- 2,607
0
votes
2
answers
4k
views
SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server
SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server.
Here's a screenshot of the error:
- 1
0
votes
2
answers
756
views
Best SQL Server Configuration with this hardware
I just received my new SQL Server from Dell. The server will be serve approximately 15 OLTP databases which average 10GB in size.
Here are the basic specs:
Dell PowerEdge R510 with up to 12 Hot ...
- 187
2
votes
1
answer
7k
views
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.
- 368