Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql]

Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [mysql], [postgres], [mssql], or [oracle].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1284 questions
2
votes
2 answers

SQL Management Studio Can't Connect to Database---Microsoft fixes failed

I just installed MS SQL Server 2014 a couple days ago and it was working fine until today. I attempted to connect using the Object Viewer and I got the error message Cannot Connect to MyserverName. Additional Information: A connection was…
austin
  • 21
  • 1
  • 1
  • 2
2
votes
1 answer

Find Full or Differential backup from .bak (with powershell or by any other means)

I'm trying to determine whether an MS SQL backup file (.bak) is Full or Differential. Is there an easy way to do this? A way of doing this in powershell?
Ryan Killeen
  • 31
  • 6
2
votes
1 answer

Placement of OS and SQL files

we are in process of setting up our SQL server which is clustered across 2 HP DL380p servers using a HP P2000 for the shared storage with 2 raid 10 (8 disks) arrays and raid 1 mirror (2 disks). We have created 3 LUNS (LUN10, 20, 30) and have created…
dqnet
  • 305
  • 2
  • 9
2
votes
1 answer

SQL server intermittent connectivity issue every 4 or 5 days

I have a .net web application that calls sql server 2008 running on a different server. From last couple of weeks, after every 4 or 5 days, web applications connectivity to sql server becomes an issue. Web application fails to connect to sql server…
circuit123
  • 21
  • 2
2
votes
2 answers

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. The job failed. The job was invoked by User…
Sadat Mainuddin
  • 121
  • 1
  • 1
  • 3
2
votes
1 answer

SQL Named Pipes across Site to Site VPN

Running into SQL issues and I can find the exact problem already posted here on SF. I have a SQL server running on a 192.168.16.x subnet on one side of a site to site VPN. I have a workstation on a 172.16.100.x subnet on the other. SQL Browser…
user201745
  • 33
  • 1
  • 3
2
votes
1 answer

How to View the IP routing table

How can I see ip routes I've added with ip route add default via x.x.x.55 table test1 for example I added 199 test1 and 198 test2 and 197 test3 to /etc/iproute2/rt_tables then I run: ip route add default via x.x.x.55 table test1 ip route add default…
Orlo
  • 231
  • 1
  • 3
  • 11
2
votes
1 answer

SQL error log can't create/write to file

I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :) I'm running WordPress on a developer plan VPS over at media temple (meaning I have root…
aaa
  • 21
  • 1
  • 2
2
votes
1 answer

DBLIB PDO driver keeps failing when trying to connect/query Microsoft Azure SQL database

So I'm using Linux (ubuntu) and I'm trying to connect to a Microsoft Azure SQL database. Server information: The server address is a1a1a1a1a1.database.windows.net (a1a1a1a1a1 is a placeholder for my server name) The database name is MyDatabase The…
B1NARY
  • 51
  • 1
  • 5
2
votes
2 answers

MySQL reclaim index space after large delete?

After performing a large delete in MySQL, I understand you need to run a NULL ALTER to reclaim disk space, is this also true for reclaiming index space? We have tables using > 10G of index space and have deleted/archived large chunks of this data…
cdunn
  • 21
  • 1
  • 2
2
votes
1 answer

port number of SQL Server

I am wondering what ports are used by SQL Server database engine? I need such port number to write configuration scripts to grant access to specific port of the machine installed with SQL Server to make it safe. A related question is whether SQL…
George2
  • 1,137
  • 6
  • 22
  • 41
2
votes
3 answers

MySQL Injection Attacks? Random URL's Causing Errors

We just started running our own web server a few months ago on Rackspace (they are great). I use NewRelic (also pretty cool) to monitor server usage and I am getting error alerts that appear to me to be injection attacks? Wondering if anyone can…
Nick8675
  • 23
  • 3
2
votes
1 answer

Does changing a Service from Automatic to Manual mean that it is unable to be started by other services/applications?

Morning all. We have a script that checks for services that are set to Automatic, but not running. It alerts us if this is the case. We've got a couple of services, like SQL Server Active Directory Helper, which are set to Automatic. They start, but…
Jack Webster
  • 21
  • 1
2
votes
0 answers

Restricting access through ODBC to only schema views SQL 2008

I'm pretty green to SQL security, so maybe someone can help me. We've got a database application that, when installed, by default grants the public role access to all the tables in the database. When you create an SQL user, it adds the user to the…
user160456
  • 21
  • 3
2
votes
2 answers

MS SQL Server 2012 - Unable to access Instance on localhost

5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error: ================================================================================== A…
loonison101
  • 31
  • 1
  • 1
  • 4
1 2 3
…
85 86