September 2, 2008 at 2:58 pm
1.Is it possible to bulk update from excel?
2.I had a database on a network with windows authentication now I can,t use that anymore, is there a way can change back to windows authentication form the configuration manager. I am an admin of the server.
September 2, 2008 at 3:00 pm
It is possible to bulk update from Excel.
I don't understand your second question. Do you mean that the server is no longer configured for Windows authentication?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 2, 2008 at 3:12 pm
I am new to sql server could you please give me an example for the first question? I have search and could not find any. For the second question I get this error if I tied to access the Db TITLE: Connect to Server
------------------------------
.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
September 3, 2008 at 7:36 am
You can use OpenRowset to query Excel files, and you can use Update From to update from anything you can query. Or you can import the Excel file into your database and then use that (this method is faster if there are more than a few hundred rows of data in Excel).
On the server connection, you can't change settings if you can't connect. Maybe try a remote-desktop connection to the server and see if you can log in to the database from there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply