It was a bit of a pain connecting to an external MS SQL 2005 server so that I could make a local copy of a database on my local machine which had MS SQL 2008 express. I am using SQL server managment studio to connect to the servers. I had no problem connecting to my local server, and I could connect to the remote server. However, when I would try to browse for the databases I would get an error;
I'm not sure why I weas getting this error as there wasn't anything I saw connecting the database specified and the database that I was referencing.
However, with a little googling I found the resolution, I had to
- Select the "Databases" folder under the server connection
- Go to view -> Object Explorer Details
- Right click the column headers and deselect "collation"
No comments:
Post a Comment