Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [sql-server-2008]

Microsoft SQL Server, commonly referred to as simply "SQL Server," is the relational database engine developed by Microsoft. MS SQL Server 2008 was released on August 6th, 2008, and is major version 10 of the application.

Filter by
Sorted by
Tagged with
0
votes
0answers
15 views

CAST (scope_identity () AS int) returns a bad value MS SQL

I have been developing a program for a long time which, after executing SQL INSERT using CAST (scope_identity () AS int) returned the new id number like this: EndID = (Int32) cmd.ExecuteNonQuery (); ...
0
votes
0answers
10 views

Secondary nodes synchronization issue on Multi-Subnet Alwayson Availability Group

we have a Multi-Subnet Always-on Availability Group setup with 4 nodes(2 nodes in datacenter A and 2 nodes in datacenter B), running on SQL Server 2014 SP2 and os (windows 2012 R2). frequently the ...
0
votes
0answers
50 views

SQL alwayson manual Failover Cluster failed because a duplicate IP address detected

When I manually tried to make a failover I got the following errors: "SQL always on Cluster IP address resource listener cannot be brought online because a duplicate IP address was detected on the ...
0
votes
0answers
34 views

SQL server slows down fast

I have large C# application doing heavy I/O on our SQL 2008 R2 server. It's been running fine, but I've had to make some changes in the application, which has made the I/O load even heavier. The ...
0
votes
0answers
89 views

SQL 2008 issue: The request failed or the service did not respond in a timely fashion

I have a server running SQL server 2008 and I got the following issue today when trying to run my sql service instance "The request failed or the service did not respond in a timely fashion" And ...
0
votes
0answers
11 views

Database Refresh SQL Server

I am a new into the project and we don't have any documentation. I have SQL Server DEV environment where I have numbers of databases. The source databases should refresh the analysis database after ...
0
votes
0answers
12 views

Do SQL Server Alias' work across a network?

We have a server entering end of life. We have multiple apps that hit that server. So that we don't have to manually change all of those apps to point to the new server I wanted to use an alias. The ...
1
vote
1answer
63 views

SQL Sever Management Studio 2008 does not let me back up my database

I tried to back up a server I created in SQL Server, but I received the following message: TITLE: Microsoft SQL Server Management Studio Backup failed for Server 'LAPTOP-6D0L83DV\SQLEXPRESS'. ...
0
votes
1answer
11 views

using Sql Management Studio 2008 list past connections

when you open up sql management studio you can select server, and get a list of remembered connections. I don't care about getting pw and but I would like a list of remembered or past connections. ...
0
votes
0answers
10 views

SQL Server error after my log file got deleted

I get the error you see below when I've tried to restore the database from MDF file. Is it possible to restore the database from the MDF file without having the log file (LDF)?
1
vote
0answers
24 views

What does it mean “Microsoft SQL 2010 R2” as an application requirement?

I have this terrible doubt of windows and hope someone of you might know what is it. I bought a contability software (here in mexico there are few providers cause they are regulated), the thing is ...
1
vote
1answer
219 views

How to reduce the database size of MS SQL server

I have a website that runs on MS SQL Server 2014 Enterprise with two clustered virtual machines and AlwaysOn. A database backup is created each night and the size is now 20GB. On my laptop, I also ...
0
votes
0answers
32 views

Cannot connect to my local instance in SQL Server 2008

I'm completely new to SQL Server. Basically I have installed SQL Server 2008 and now I want to log in with local server name but I get this message: print screen However, when I goto Services in ...
0
votes
0answers
96 views

SQL Server 2008 SA account locked

Trying to access SQL Server 2008 database of production server but admin and SA account was not accepting it. After trying several time SA account is locked. How to unlock it without any production ...
1
vote
1answer
157 views

PHP Query to SQL Server through IIS 7.0 on Windows Server 2008 R2

So I am building a webpage on my Windows Server 2008 R2, I have IIS 7 configured to work on the intranet so I can access the site locally from any machine within my Active Directory/Local Network. ...
2
votes
0answers
454 views

SQL Server Express no longer starts up automatically

I had SQL Server 2008 Express (SP1) on Windows 7 Pro and it was working fine. After upgrading to Windows 10, SQL Server 2008 Express was still working normally. However, after the last Windows update (...
1
vote
1answer
294 views

How to schedule a recurring SQL Server 2012 DB backup using sqlcmd ?

I'm looking for a way to create a monthly recurring backup of a SQL server database using sqlcmd. I've seen scripts for SQL Express, but they only execute once. I'm looking for a sql script that will ...
3
votes
1answer
290 views

Permission to query WMI

I have a project to remove admin rights from our users. An application we use, during upgrades, runs a query against WMI: Namespace: root\Microsoft\sqlserver\computermanagement10 Class: ...
2
votes
2answers
1k views

SQL : Restrict view of tables in database

This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
3
votes
1answer
245 views

Can't list SQL databases like directories with PowerShell

I'm trying to list databases with PowerShell. I'm able to use Inkoke-Sqcmd cmdlet, but I can't list databases with this command: dir SQLSERVER:\SQL\myserver\sqlinstance\Databases Get-ChildItem : No ...
54
votes
2answers
124k views

Where is SQL Configuration Manager in Windows 10?

I just have upgraded to Windows 10. I can't find SQL Server Configuration Manager. I have MSSQL 2008 and 2014 installed but there is no configuration manager in "All Apps". This is just a picture of ...
0
votes
0answers
3k views

Unable to connect to sql server 2012 with SSL encryption enabled using sqljdbc4

I am trying to connect my web application to SQL server 2012 with SSL encryption enabled using sqljdbc4 but i get the below error : com.microsoft.sqlserver.jdbc.SQLServerException: The driver could ...
1
vote
0answers
598 views

Cannot install SQL Server 2008 R2 express. Compiler returned error 0x8007005

First off, I'm having a very similar issue to this StackOverflow post here: https://stackoverflow.com/questions/31681386/sql-server-configuration-manager-wont-start-wmi-returns-error# Installing SQL ...
0
votes
1answer
4k views

Updating MS SQL Server from 10.50.1600 to 10.50.1617

How do I update my MS SQL Server from the version 10.50.1600 to 10.50.1617? I have downloaded the KB from here https://www.microsoft.com/en-us/download/details.aspx?id=26304 but i am still not ...
0
votes
1answer
267 views

Creating a database in Visual Basic 2010 Express

I'm studying computing and I need to make a program for my project. My project is a fast food ordering system which needs a database. While trying to add a SQL Service Database I get an error message ...
1
vote
0answers
65 views

Sql server 2008 R2 is losing Intellisense after installing Visual Studio 2010 SP1

after installing service pack 1 on visual studio 2010 , i have lost Intellisense in sql server 2008 r2 , what should i do in order to fix this issue ?
0
votes
1answer
149 views

How to share a SQL Server 2008 Standard edition database to another on a computer (wireless network)

Does anyone know how to set the properties of database to be shared through wifi network? I'm running windows 8.1 OS and the other computer I need to share with, is Windows 7. I tried to use 'adhoc' ...
0
votes
0answers
1k views

SQL Installation hanging on windows 10

I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2). Everythings hangs, and always at this point. I've a feeling its a .net related issue ...
0
votes
1answer
647 views

Time and date filter in SSRS 2008

I am looking for an expression that can filter a time and date column to 4 hrs prior from what the actual value is. Example: 5/27/2015 5:00:30 pm So I am looking how to get: 5/27/2015 ...
4
votes
3answers
34k views

SQL Server not working after upgrading windows 10 from windows 8.1

My Sql server 2012 has stopped working and now its not letting me login. Here is the error: https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing TITLE: Connect to Server ...
0
votes
1answer
981 views

Can't install SQL server 2008 or SQL Server 2014

When I try to run the SQL SERVER 2008 setup, it shows the following error and exits: SQL Server Setup has encountered the following error: Unable to cast object of type 'System.Configuration....
2
votes
1answer
217 views

How to pick rows in MS SQL based on column values?

I want to pick SourceId & Currency based on Count value. Problem is within a set I've to ignore all data where Count = 0 if there is any value greater than 0 but if all the counts are 0 within a ...
2
votes
2answers
655 views

Cannot uninstall SQL Server 2008 from Windows Server 2012 r2

I have install SQL Server 2008(64-bit) express on the virtualbox in virtual machine, with guest os Windows Server 2012 R2(It is also domain controller). After the installation, I decide I would like ...
0
votes
1answer
48 views

SQL server connects after browser restart

I am using SQL server 2008 trying to connect the server using management studio using ssms with server name including ports and named instance with SQl authentication . Windows firewall is disabled . ...
0
votes
1answer
86 views

SQL Server 2008 Backup to networked drive

When I go to backup a SQL database - I only see options to do the backup on a local disk. Is it possible to backup to a network drive directly?
0
votes
1answer
485 views

Mysql Connector crash on SQL Server 2008

I would like to create a linked Server betwenn my MYSQL Server and a SQL Server 2008. I already installed the MYSQL Connector ODBC drivers 5.1 (previously the 5.3 Version but same problem) on my SQL ...
0
votes
0answers
48 views

Change SQL server back to a trial

I need to convert a SQL Server 2008 instance on a VM (which is licensed) back to a trial. What are the steps to do this? REASON for this: Need to give a VM with a custom solution on it to a 3rd ...
1
vote
1answer
749 views

Move SQL Server 2008 to virtual machine

I have a physical server that uses SQL server 2008 in managing my warehouse. We desperately want to virtualize this server. Would I need to buy a new SQL server license? Or is there a way to use ...
0
votes
1answer
300 views

sql server 2008 Management Studio does not see my copied database

I copied my database (mdf and ldf files) from my server to the cloud. Previously I have done it from one local server to another. I put it in the same directory (MSQLSERVER/../../data, confirmed that ...
0
votes
1answer
226 views

SSMS view designer - how do I give a table an alias?

I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible. Case in ...
0
votes
1answer
8k views

Remove column header from sql query output in powershell

I want to remove column header from sql server query output. I did the search but not found any solution. I have a script. $Database = "temp" $Server = "localhost" $AttachmentPath = "output.csv" # ...
0
votes
1answer
78 views

MS SQL Server 2012 drives

I am buying machine for MS SQL Server 2012 Standard and I have questions about drives and performance. How to locate OS, database, logs, backup on WD RE4 500GB and Intel SSD DC S3500 120GB? OS, logs ...
2
votes
2answers
2k views

Try to resolve logged error SQL Server/SQL Server 2008 R2

I have this logged error #10016 The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID {46063B1E-BE4A-4014-8755-...
2
votes
1answer
11k views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
1
vote
1answer
113 views

SSMS 2008 is stuck because Connect to Server window is hiding

Launching SQL Server Management Studio 2008 after rdp or similar display config funny business, the Connect to Server window is sometimes hiding in the corner of a monitor. The program seems stuck, ...
1
vote
2answers
10k views

How to start/open SQL Server Express 2008 in Visual Studio?

I have Windows 8 and have installed full-pack Microsoft Visual Studio 2010 Ultimate Edition. There was no error while installing Visual Studio 2010 Ultimate Edition. I exactly don't know which ...
3
votes
1answer
412 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 ...
0
votes
1answer
183 views

Move multiple SQL Server 2008 databases from C: to D: at once

I have SQL Server 2008 R2 with 323 databases consuming some 14 GB on my C: drive, a fast SSD. Because I want to reclaim some space on my C: drive, I would like to move them to my D: drive. I have ...
0
votes
1answer
400 views

Error when install SQL server 2008 the application was unable to start correctly (0xc0007b)

"the application was unable to start correctly (0xc0007b).click ok or close button to installing application)" Error come when i try to install SQL server 2008 in my system. How can i fix this error?...
6
votes
1answer
2k views

SQL Server ODBC authentication errors

I'm trying to connect to a SQL Server 2008 database from a 3rd-party application through an ODBC connection. I am having success when the ODBC is set up with Windows Authentication but not when it's ...