New answers tagged

0

I was informed that Azure had to replace some hardware and the error went away. One of the cons of the cloud...


0

websites with this behavior are Dotnetnuke and I find that it's a problem in dotnetnuke and not related to sql server settings: more details : http://www.dnnsoftware.com/wiki/under-construction


0

It does work. It would python but in the end decided to do it with bash with FreeTDS like this: ~$TDSVER=8.0 tsql -H serverIPaddress -p portnumber -U domain\\username EOS >EXEC msdb.dbo.sp_start_job @job_name = 'jobname' ; >GO >EOS it will prompt for password... this can go in to a script to execute (whenever) probably call it from a python ...


3

I don't think I can give you a magic "be worried here" number, where anything under that number is "okay" and anything over that number is "bad." That said, there are a number of red flags in your question, at least to my point of view: "nobody seems to really know what specs the server has." "They've asked us to dump ~730M records into their database ...


0

SQL Server 2000 run on Windows Server 2008 (HyperV VM). That's the configuration we have at the moment. Although you can find on Internet that this is not suported, i can tell you that runs correctly and, using a litle tricky steps, you can still design and execute the SQL Server 2000 DTS from the Legacy folder on Management Studio 2008. ...


0

I cannot believe this, but apparently right before I copied this virtual machine, someone committed code with the wrong SQL Server address. I didn't realize that commit had made it onto that machine. So it's my own dumb fault for not paying enough attention.


1

No. Add a user with the same SID to the original database (the source database).


0

Our admin found out, that the problem is with DNE LightWeight Filter. If this monster is disabled everything works as it is supposed to (no random disconnects with strange errors). You can disable it if you go to Control Panel / Network and Sharing center / Change addapter settings. Right click on your network device and select Properties. Deselect DNE ...


0

The most secure method would be to not connect them directly to the internet at all. You can use a firewall (either external or the system's), only allowing the ports strictly needed to be accessed by the public internet access through the firewall. Set the default to Deny on the public-facing ports.


0

I had this error while trying to connect through TCP. But TCP was already enabled and services restarted. In my case I had to enable dynamic ports on the TCP Connection: Screenshot:


0

Can't give you a definitive answer, but a few things I would check: Check that there are no errors being reported on the database server itself (check event logs). I think this is unlikely given that you said it worked fine for your co-workers. Are you using the same driver (same or later version) to connect as your co-workers? Is there a problem with your ...


0

We added am "Execute T-SQL Statement Task", which calls a stored procedure, with the name of the Maintenance Plan as a paramater: EXEC server.schema.SP_SENDALERT 'plan.subplan'; In that stored procedure, we query back to the SYSJOBS and SYSJOBHISTORY for the plan to obtain the message for the last 'failure', which we then send to 'IT Support' as part of a ...


0

you can also look at your queries and recode them so that they have less impact on tempdb.


0

I just asked my DBA about this because he disabled an extremely useful function I use for troubleshooting. After doing a lot of research and reviewing answers from people significantly more experienced than me, I tend to lean toward the middle on the issue of disabling xp_cmdshell. One one hand it's ridiculous to be absolute on the idea of disabling command ...


0

I think it uses a special backup type called "Snapshot Backup". From the SQL Server 2008 documentation: SQL Server snapshot backup is also used by Microsoft Windows Server 2003 Volume Shadow Copy Service (VSS) and by all the backup software and storage software that uses this framework. For more information, see SQL Writer Service. It is all very ...


1

if you want to change your database from Standard to premium you will have to remove the replica first then change to premium, then add the new online (Read-Only) replica. Right now you have got a Standard tier database you will have a Online (Non-Readable) replica if you change to Premium you be able to add an online (Read-Only) replica. I am a cautious ...


0

Without discussing the security issues of granting non IT admin users admin rights to the database. To solve below problem: The obvious "solution" is to make one user a member of a db_owner role for the specified databases, and give them rights to update the databases (set inside our program). However, this does not work, as any new tables are "owned" ...


1

I got an answer back from the hosting company that hosts our VPS and, lo' and behold, they block port 1433. They gave me a different port to use and all is well! Thanks to everyone who commented. Not sure why dynamic ports did not work when I tried it, but it may be that SQL Browser could not get through the firewall either on UDP port 1434 to do its job ...


0

I had the same problem connecting a PC to a SQL database located on server. After trying all the same thing you did, I found a solution which was so simple I couldn't believe it worked. What you need to do on your machine is: 1. run "cliconfg" and enable Named Pipes and TCP/IP protocols 2. run "obdcad32.exe" and add a default named pipe connection to your ...


1

The question is which is "better"? Which is hard to answer since it relies on the context, values and priorities of the questioner. Personally, I like SQL auth. AD is another thing to run and support and manage service accounts. AD needs to be available in your hosting environment. AD would make it hard to move to the cloud or hybrid cloud. AD makes it ...


0

Took me a bit to figure this out. While the netstat showed that the port was open, the Win 2012 server advanced firewall was blocking the port. So, important to note here that Windows Firewall overrules whatever is in netstat All we needed to do was create a new rule to open that port, and then we tested via a cool new command line command called ...


0

I was able to get around this by creating a new local group called SQLUsers, I added the administrators group to the SQLUsers Group and was able to add this into the SQL server security > logins



Top 50 recent answers are included