The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
6 views

Adding a certificate to be used by MS SQL SERVER

I have MS SQL SERVER 2012 installed on my Windows 8.1. Now I wanted to enable SSL encryption in it. What I did was: 1. Run - > MMC 2. Add snap-in 3. Added certificate (personal) for local computer ...
0
votes
0answers
88 views

PORT FORWADING TPLINK-TL-WR740N

i was up to using my local MSSQL database with my live application so that i can fetch the data from my personal pc from the web application. i am creating my web application in sailsjs. and i am ...
0
votes
0answers
10 views

Access freezes before I can change data source

I have an .adp file that connects to MSSQL Data Source A, on Intranet #1. I copy the .adp to Intranet #2, including moving the .mdb to MSSQL Data Source B. I try to open the .adp to change the Data ...
-1
votes
1answer
40 views

sub versioning with a TSQL Mac osX client

How can i setup ANY t-sql mac client connecting to a ms sql server and connect it to our svn server? i am looking to mimic MS Management studio + red gate. where once you have added the SVN link you ...
0
votes
0answers
27 views

If MSSQL machine is maxed out on resources, can it drop off the network and become un-pingable?

The issue is that our SQL machine will just disappear from the network with request timed out when I attempt to ping it. I have to deal with an "IT Guy" who is telling me that it is because Microsoft ...
0
votes
0answers
9 views

redirect MS SQL through Ubuntu

I'm trying to redirect a Microsoft SQL connection from local LAN to VPN via Ubuntu The Ubuntu has connection to both networks I want to be able to connect SQL from my PC to the Ubuntu and it redirects ...
0
votes
0answers
17 views

How to view MSSQL logfiles to investigate errors made by remote connection?

I am having MSSQL 2012 running on some computer, and I am connecting to a certain database from a different computer remotely to perform a bunch of SQL commands. However, these commands have problems, ...
0
votes
0answers
14 views

MSSQL administration tool without installation

I need a tool to have a look at mssql database and do some basic CRUD operations. To use it in every environment, it should be an installation-free EXE. Do you know such a tool? Before you ask: I ...
0
votes
1answer
19 views

Join 2 mssql queries

I need to join to MSSQL queries, but I am not getting anywhere with this. Both queries return a single value: SELECT COUNT(*) FROM sysjobhistory WHERE run_status <> 1 AND step_id = 0; ...
0
votes
0answers
25 views

Troubleshooting an Access rowsource query with a server name specified?

I have a list box rowsource query that addresses a specific MS SQL server in it: SELECT DISTINCT alistname FROM differentserver.dbo.Inventory ORDER BY alistname When I try to run this query in ...
0
votes
1answer
2k 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
228 views

Can i input duplicate values in foreign key column

A small but important question can input null and duplicate values in foreign key column connected with some another table with same column identity and values as far of my knowledge it is not ...
2
votes
1answer
179 views

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: ...
0
votes
2answers
700 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 ...
1
vote
0answers
217 views

Cannot load riched20.dll into memory

In WindowsXP 64bit while installing MSSQL 2008 installation terminates showing error message "Cannot load riched20.dll into memory..." How to fix it?
2
votes
0answers
78 views

SQL Server is not started in windows 8

I created the local service. My server name is like sqlitesync.com. In my database folder created the configuration (web.config) and WCF web service (AuroraSyncService.svc). When I test this service ...
1
vote
2answers
1k views

MS SQL Server 2012 Express Setup crashes with .NET error

I'm trying to install MS SQL Server 2012 Express on a virtual machine at a client. It's fresh install of Windows Server 2008 R2 Enterprise SP1. I added the "File Services" and "Application Server" ...
0
votes
1answer
79 views

SSMS starts without login prompt and stays inactive

recently my SSMS started working really weird, wasting my time. I am working on a laptop connected to additional monitor. SSMS starts without login prompt, and stays inactive as long as I dont shut ...
0
votes
1answer
240 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
0
votes
1answer
52 views

What Microsoft product is used to draw a Relational Database for MS SQL?

What Microsoft product is used to draw a Relational Database for MS SQL? For MySQL I have used MySQL Workbench what is similar for MS SQL?
0
votes
1answer
249 views

Error importing database in Windows Azure

Just to test the MSSQL backup/restore capabilities of Windows Azure, I selected a test database and chose the "Export" option. It prompted me to select a storage location and I chose an appropriate ...
0
votes
2answers
331 views

What versions of Windows does MS-SQL come pre-installed on?

We have an emergency mgmt. application that runs on a flash drive so that in an emergency a PC can be commandeered to run the app. We are considering using MS-SQL instead of MS-Access, so I am ...
1
vote
1answer
239 views

Administrator can run a application but produces error while a administrator previllaged user can run without error

I have an application which can run as admin prevailed user without error but while administrator runs it it produces error. The input string was not in correct format-application error. I tried to ...
2
votes
1answer
475 views

WinSCP command line for SSIS package

I am using the command line : option batch on option confirm off open ftp:// username :password hostname:port cd directory name ---- directory on FTP option transfer binary put file name on FTP ...
0
votes
1answer
899 views

Access MS SQL server from CentOS (OpenOffice calc)

I installed FreeTDS in CentOS 6 and I can connect from php to remote MS SQL server. However I cannot set up odbc connection so that it shows in list of ODBC connections in OpenOffice apps. If my ...
0
votes
1answer
109 views

A proxy-kind program that listens on local port and transfers everything to LAN server

I'm administering a few WinXP machines from which one is a MSSQL server/workstation. WinXP is a must because of the program the office uses. I was thinking of moving the MSSQL server to another ...
1
vote
1answer
433 views

User Friendly CSV to MSSQL import with column match

Hi before I reinvent the wheel I'm trying find something to allow a user to take .csv files and graphically match the columns in the database table to the columns in the csv file. I know this can be ...
1
vote
1answer
618 views

Migrating Access Database to MSSQL backend

We have a database at cadets that uses Access for all functionality and data. It's starting to get slow and not always update. I know that Access 2003 and higher (not sure on older ones) lets you ...
0
votes
1answer
143 views

ADODB Connection - Webserver doesn't resolve the hostname of the mssql server

I have a mssql connection resource file as belows: <% Set Conn01 = Server.CreateObject ("ADODB.Connection") Conn01.Open "PROVIDER=SQLOLEDB; Data ...
2
votes
1answer
4k 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 ...
0
votes
1answer
2k views

How do I make a dump of a MS SQL database using SQuirreL SQL?

Unfortunately I cannot use Microsoft's database tool to access my MS SQL server, so I need to use another tool like SQuirreL SQL. How can I make a backup (i.e. dump) of the database?
0
votes
1answer
3k views

Custom forms in Sharepoint with MS SQL Server as Backend. Is it possible?

We're evaluating using SharePoint 2010 as our project management tool. Specifically, the system needs to satisfy the following: Discussion groups Project management (simple issue tracking, no ...
2
votes
1answer
344 views

What program can be used to insert/modify/delete rows of MS SQL Compact?

MS SQL Server Management Studio 2010 seems not support compact databases (add/remove records). Is there any utility? Free one would be nice.
1
vote
1answer
247 views

SQLCMD -L option with a smaller timeout

I am trying to use the sqlcmd -L c command to find out the instance name of the SQL server running on the local machine. It succeeds, but I have to wait for a full minute, for the tool to realize that ...
0
votes
1answer
561 views

Looking For Live Exchange Backup Solution Utilitizing the Cloud (S3, Azure, whatever) [closed]

I have been tasked with finding some software or a service which can backup user mailboxes from a live Exchange server and SQL databases from MSSQL servers much like a Barracuda device might perform. ...
1
vote
1answer
850 views

Can't add PHP extension “mssql.so”

I want to add mssql.so extension to my PHP. I've already put it in the extension_dir and the line "extension=mssql.so" is in my php.ini. I restarted apache but I can't find the extension in ...
0
votes
2answers
19k views

What ports does MS SQL Server use for ODBC connections?

I require our firewall to allow ODBC connection from clients to the MS SQL Server. Which ports should be opened for this?
0
votes
1answer
191 views

Problem while installing Microsoft SQL Server 2008 as a user with Administrator rights

I am using Microsoft Windows XP service pack 3 User Accounts: VC3(Type: Administrator) and Administrator Question I am trying to install the Microsoft SQL Server 2008 in VC3 After half of the ...
2
votes
1answer
2k views

How to determine server name for ms sql

How do I determine the server name for ms sql server. How do I make one, if there is no default server name. I need this so that I could use it as a database Update: I tried using the computer name + ...
0
votes
4answers
913 views

What are the best tools for modeling a pre-existing SQL database structure?

I have a MS SQL database that has been running strong for 10+ years. I'd like to diagram the database structure, without spending hours laying it all out in Visio or something similar... I've ...
8
votes
9answers
18k views

Why does it take so long for SQL Management Studio to connect?

Considering that Microsoft SQL Server is not, technically, a slow database management system, I keep wondering why it often/usually takes such a long time for SQL Management Studio to connect. This ...