What would the reason of getting the following error?
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.
I have a clustered SQL instance set up at SERVER01\dev08
It's assigned to a static port of 1466. Can I set up something which will let users connect to SERVER01 and hit that port?
If this is possible, what problems might it create (all traffic coming to this name hitting only one port)?
It seems that DNS has nothing to do with ports - nor does the F5 big IP.
Hi, I was wondering if someone could tell me if there is any potential security breeches that could occur by connecting to a sql database that does not reside at 'localhost' i.e. via ip address?
In the long tradition of having hidden features, let us have a list of hidden features in MySQL.
Do put one feature per answer.
Also See:
Hidden Features of Linux
Hidden Features of PowerShell
Hidden features of Oracle Database
Hidden Features of Windows 2008
Hidden Features of Solaris/OpenSolaris
Hidden Features of SQL Server
Hidden Features of IIS (6.0 / 7.0)
I am currently using a database from an installed instance on my web server in a VM on Azure. I was thinking about moving it to an actual Azure Database so I could load balance the web server. Does the Azure database work the same way as a straight install? Will it cost more or the same since I am just moving to a new server? Basically looking for advantages and disadvantages. I am familiar with SQL Server Management Studio.
Hi,
I have two server. One with sql server and another with dbf.
I would like to access form MSSQL server to dbf server.
But i haven't access to this server. How can i managed that?
Thanks
Julien
I have 60 Gb of RAM on server. Windows 2008, 32bit with PAE.
One Sql Server 2008 Express Instance can use 1 Gb of RAM.
So if I install 60 instances, each can use 1 Gb of RAM, right?
And the second question, what will be if I install 64bit system and use many Express instances?
we are using Sybase SQL Anywhere 11. I am using command line to install/init database, dbinit -dba %username%,%pwd% -p 4k %dbLocation%, and start database server, dbsrv11 %dbLocation%, in a batch file.
What I really want is install my database as Windows service and can be start/running automatically when machine get reboot. But I want to keep using batch for easy intall/uninstall/change it.
Any Sybase expert here?
I need to design a system which represents multiple "projects", one per client in SQL Server , something similar to StackExchange... same data model, different sites (one per customer). Each project has the same data model, but is independent of all others. My inclination is to use one database to store all projects. What is your recommendation?
How well does upgrade advisor work for doing SQL Server 2000-2005 upgrades - what are the significant gaps that I might have to address through other means?
Do data sources that you set up (particularly to SQL Server) travel with a mail merge document?
In other words, if I set up data sources in a mail merge document on my machine and then save and send that document to a co-worker and she opens it on her machine, will the data sources still be there when she opens it? Or, will she have to set them up again herself?
Hi.
I am setting up a BizTalk 2009 Server production environment and I wonder if this tutorial: http://msdn.microsoft.com/en-us/library/cc558972(BTS.10).aspx is still fairly accurate for an installation on all the latest platform software (Hyper-V, Windows Server 2008, BizTalk Server 2009, SQL Server 2008)?
Is there anything like this but more up to date?
Any other advice about this process and links to articles, blogs & tutorials would be appreciated.
On windows server 2003 there was an option to allow a resource to interact with the desktop, this allowed you to run computer management mmc snap-in on the virtual name of the cluster, allowing you to manage permissions of the private message queues on the cluster. Windows Server 2008 failover clustering has removed that checkbox, so applications can no longer interact with the desktop. My question is then how does one go about managing private queue permissions on the clustered (the virtual name) server?
I am using VBA to pull from a SQL table and it automatically populates cell E14. Not sure why it's that cell, but is there a way to specify which cell it pulls the data into?
Here's what I have right now:
strSQL = "SELECT distinct Source FROM dbo.Simulations WHERE SimulationID = 5
Or should perfmon be limited to a Dev/QA server with load tests that simulate production activity?
I'd like to run perfmon for a two days (like Sql Server master Brent Ozar suggests) to get an overall feel of my web app's database performance.
There is a debate going on in my group as we plan to use SharePoint 2010. We want to use Remote Blob Storage (RBS) instead of storing files in the SQL tables themselves. If we use RBS, do the files people upload still count against their site collection quota?
To me, it seems obvious that they would. To others in my group, it seems obvious that it wouldn't.
SQL Server 2008 db instance is installed on a win 2003 server, networked (but no domain) VM.
I can browse a cube from BIDS on the same VM, but when I try to browse the same cube on a windows 7 (home premium) networked machine, I get a connection error. The error suggests checking the datasource settings which I have, and when I click "test connection" on the datasource it is successful.
Looking for probably causes and solutions?
Hello
I have 500GB of database stored in SQL Server. Because it has too big a database, it takes time to update and insert data. Now the case is that I want to partition the data. So which partitioning techniques should I use? Or is there any other technique which will improve my performance?
Possible Duplicate:
How can I handle emailed job control files for SQL Server?
how to write batchfile/storeproc for cheking the mail in the inbox using jobmanager
I'm finding it very hard to estimate how much my web application might cost running in Amazon's cloud? My app is similar to stackoverflow.com - asp.net, ajaz, sql database. Can anyone estimate how much it might cost to run stackoverflow in Amazon's cloud?
Has anyone successfully gotten HP Quality Center 10.0 installed and running using the as-yet unsupported Microsoft SQL server 2008? Have you hit a specific issue? e.g. any issues with full text search etc.
Hi all,
I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring.
Does anyone know what's the problem?
Thanks,
Ling
I was wondering if there is an easy way to trigger an e-mail alert on Windows Server 2008 when any logical disk partitions become low on space. I have 2 SQL servers that have come close to running out of disk space because of the DB log files.
Thanks,
Ryan
I followed the steps here to set up Sharepoint integration with reporting services (SSRS) using native mode. (i.e., get a report explorer and viewer web parts)
However after adding the cabinet file e.g.,
STSADM.EXE -o addwppack -filename "C:\ Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall
I still don't see report explorer in the web parts list. I'm very stuck and confused :-(