Witam!
Czy instalowal ktos z was lokalnie "obok" Visual Studio (w moim przypadku 2008) SQL Server 2008 RC0 (zainstalowalem edycje Express)? Po instalacji SQL2008 tak mi on namieszal w systemie ze w Visual Studio nie moge korzystac z uwierzytelniania SQL gdy lacze sie z baza w wersji 2005, a przy tym mam taki komunikat bledu:
Unable to add data connection.Failed to retrieve data for this request.Unable to cast object of type 'System.DBNull' to type 'System.String'.
Ma ktos jakis pomysl? Podlaczanie do lokalnej bazy 2005 przez uwierzytelnianie Windowsowe przebiega bez problemu. Tak samo podlaczenie sie do bazy 2008 korzystajac z uwierzytelniania SQL takze jest bezproblemowe.
Dzieki
---------------------------------------------
Webio Grzegorz Wołoszyn
Windows Hosting ASP.NET - http://www.webio.pl
Skonczylo sie na "format c:" i instalacji wszystkiego od nowa
Odważne posunięcie ;)
Polecam maszynę wirtualną i zabawy na niej, a jak wyjdzie już SP2 do SQL servera to dopiero wtedy zainstalować u siebie ;)
Paweł Hofman
dorzuce jeszcze 5 groszy do tego tematu. Po zainstalowaniu SQL Server 2008 Express (wersja RTM) i probie polaczenia za pomoca SQL Server Management Studio 2008 Express do serwera SQL Server 2005 Express (nei wiem jak sie to ma do wersji pozostalych ale pewnie podobnie) otrzymywalem komunikat bledu:
The server principal 'A' is not able to access the database 'B' under the current security context (Microsoft SQL Server, Error:916)
Rozwiazanie problemu znalezione w internecie:
The server principal 'A' is not able to access the database 'B' under the current security context (Microsoft SQL Server, Error:916)Hi All!I ran into an issue that I could not resolve for two days and, with the help of MS, it is finally resolved. It was enough of a thorn in my side that I thought I should post it online in hopes that it will help some resolve it a lot faster.The error:The server principal 'A' is not able to access the database 'B' under the current security context (Microsoft SQL Server, Error:916)The issue:This issue occurs with SQL Server 2008 RC0 tools. Using SQL authentication, I could connect to database engine but I could not expand the ‘Databases’ node. It would result in the error above. The issue is with SQL Server Management Studio itself, not the database engine or any other aspect of SQL Server. I could connect to the SQL installation from another server running SQL Server 2008 RC0, using SQL authentication, and expand the ‘Databases’ node without any errors. But I couldn’t connect locally using SQL authentication.In a nutshell:Server A – While logged in locally on Server A, I could not connect and expand the ‘Databases’ node successfully using SQL authentication.Server B – I could connect to the SQL instance on Server A and expand the ‘Databases’ node using SQL authentication successfully.Based on my current understanding of the issue at hand, there are several work-a-rounds to correct this issue. Hopefully, one of them will work for you.Work around #1:1. Within SQL Server Management Studio, view Object Explorer Details window by selecting View, Object Explorer Details in menu (or hitting F7)2. Right-click on the column header and unselect 'Collation.'3. Refresh the server in Object Explorer and enumerate the databasesWork around #2:1. Within SQL Server Management Studio, view Object Explorer Details window by selecting View, Object Explorer Details in menu (or hitting F7)2. In Object Explorer window click at Databases folder3. In Object Explorer Details window right-click at the column header and select ‘Reset view’. 4. Refresh Databases folderWork around #3:1. Check the database options for the “Auto Close” setting. If it is set to “True,” change it to “False” and test again.
Dla mnie zadzialal od reki "Work around #1".