Okay as a follow up. I found the issue.
I ran c:\windows\syst em32\cliconfg.e xe
Someone put in an incorrect alias with incorrect data. I fixed it, and it worked.
Now that is the best answer. Figuring it out! Thanks me. :)
Vikki McCormick
Last Activity: Jan 5 '16, 05:00 PM
Joined: Aug 4 '10
Location:
-
No problem. We've all been there. Glad to help. :)Leave a comment:
-
We rebuilt the server everything works. No solution. Something in the install must have messed up or a setting got changed.Leave a comment:
-
Hi, Because 'id' is presumably unique and the row has to be exactly the same in every field, and if you group by all those fields and one of them is different it will register as unique and not a duplicate.
If it is just 'id' that is unique in the field, and you remove 'id' totally you'll get the list. If you need 'id', then you have to set up the select query as a sub-query and re-join that to the main table. There are other ways of...Leave a comment:
-
TCP Provider errors in SQL Server
Hi,
I have a SQL Clustered instance in a hyper-v, virtualized environment. Every server (5 of them) except for one server cannot connect to the default SQL Cluster Instance via TCP/IP on port 1433 using just the name of server (i.e. SQLDEVCLUSTER) in the connection string. I keep getting the following error. It can't be the SQL Cluster since all other servers are connecting to it just fine and everything works normal. Not having... -
Database Mirror
I have a mirrored database which is working fine for all applications. A developer wrote an application that worked before the mirror. Now sometimes he gets a connection failure and sometimes he connects fine. I see that the connection protocol being used for his app is sometimes for named pipes, so I think it tries to connect using named pipes for some reason. Maybe due to a time-out?
I advised him to include the Network attribute... -
Have you tried to connect through Server Explorer? Hit Control/Alt "S", then "Add Connection" and a dialog pops up that will guide you through the steps.Leave a comment:
-
Has anyone had to setup Sharepoint as a File Share?
We have 10 million files and over a terabyte of data and it's still growing. We need to retain everything.
Has anyone ever had to absord an entire File Share into Sharepoint? I figure I could either set up an enormous database which is scalable or I could do a filestream or possibly create a custom Sharepoint app that utilizes the filestream. The company does not want to get rid of Sharepoint.
I know there are 3rd party... -
Hmm...Currently there is running SSAS, SSIS, and SQL Server right now on a Hyper-V. The database is relatively small in the real world - 70GB. However the growth rate is around 7-10GB a month. You think adding another application to run along side of SQL Server will have no effect or do you think there is a risk?Leave a comment:
-
From a DBA stand point. You never put anything with SQL Server. You should never in a perfect world. I heard from Brent Ozar that you can put SSIS and SSRS with excel, but in all my experience, you never add excel to SQL Server unless maybe your company can afford the type of hardware to support it.
We are a small company and we are running trimmed down and virtualized. It will surely cause issues.Leave a comment:
-
Thanks for your post. They need to read in an .xlsx and output an .xlsx. I think that is a requirement and no work arounds.
I think a script task with some code might be a good solution. I saw someone doing it that way online somewhere, but I have not tried or tested that. Thanks.Leave a comment:
-
Install Excel on the SQL Server
I have some developers who want to create .xlsx files from SQL Server.
There is a claim that it necessary for me to install excel on the server in order for this to work.
Is this standard practice? They are running an SSIS package to create the files.
I think there is a c# solution that you can add with a script task to avoid installing the actual application to a server and all you would need would be this... -
CK Thanks. Ok changed to exists and we already have an index on that table, but I will check to see if any adjustments should be made.
So far so good, it's holding steady. Still getting some very minor blocking and they are resolving very quickly.
Cool. Thanks again.Leave a comment:
-
Function is Causing Deadlocks
Hi
We have a function that is causing deadlocks. I can't see anything wrong with it. Can anyone weigh in?
FUNCTION that is Called in Stored Procedures to find Previous Business Date of a specific date.
i.e. Select [dbo].[GetPreviousBusi nessDate] ('05/13/12')
...Code:CREATE FUNCTION [dbo].[GetPreviousBusinessDate] ( @inDate date ) RETURNS
-
Thanks very much for the reply. It's very helpful. Don't think we are using VAS memory. I will try to post a reply if we resolve it. We think there is something wrong with the cube, and we are rebuilding it on another DEV box. Will let you know. Thanks.Leave a comment:
-
SSAS and SSMS memory limitations
This is more about guidance than a question I think.
We have some off site developers/consultants writing reports off a cube they developed and were supposed to be managing. They keep getting this error and are requesting we up their memory to 12G.
'System.OutOfMe moryException'
We did to quiet the noise for the moment but, that takes away from other systems, namely my test servers, and I am wondering... -
Rabbit using
I gained one second. Huzzah!Code:1.ISNULL(Requests.ProcessingComplete, @AgeFromDate) BETWEEN @AgeFromDate AND @AgeToDate
Leave a comment:
-
Yes. I indexed. I will reveiw them again though to make absolutely sure I didn't put the order in wrong or something.Leave a comment:
-
I found this example. Does isNull replace the COELESCE function?
...Code:SELECT * FROM MyTable WHERE MyTable.StartDate >= COALESCE(MyTable.StartDate, "1/1/1900") /* Date selected as earliest plausible constant to avoid min() lookup */ AND MyTable.EndDate <= COALESCE(MyTable.EndDate, "1/1/3001") /* Date selected as latest plausible constant to avoidLeave a comment:
-
Ugh.. this works. I lost 6 seconds... grr.. still 20 seconds is better than 13 minutes.
Yes ck9663 it's a variable. I didn't want to post the whole thing, because it's...Code:isNull(Requests.ProcessingComplete,'01/01/1900') = case when Requests.ProcessingComplete is Null then '01/01/1900' when Requests.ProcessingComplete between @AgeFromDate and @AgeToDate then Requests.ProcessingComplete end
Leave a comment:
No activity results to display
Leave a comment: