Marko Apfel - Afghanistan/Belgium/Germany

Management, Architecture, Programming, QA, Coach, GIS, EAI

  Home  |   Contact  |   Syndication    |   Login
  187 Posts | 2 Stories | 201 Comments | 4 Trackbacks


Twitter | LinkedIn | Xing

Article Categories


Post Categories

Image Galleries



Enterprise Library


SQL Server


SQL Server

Problem If you run the “Generate database from model” wizard and execute the generated script the destination database could be the wrong one (for instance master of the SQL Server). Solution To use an own mdf attachable user database some connection information must specified during script execution. Execute your script opens the dialog “Connect to Server”. Press “Options” and go to the second tab “Connection Properties”. Select “Browse server” in the “Connect to database” dropdown box: Confirm ......

With Entity Framework 5 in Visual Studio 2012 the code first feature could let you come to the question “Where is the automatically created database located?” I run in the question after changing the model which throws during the next run this error: “The model backing the 'MyContext' context has changed since the database was created. Consider using Code First Migrations to update the database ( Okay – clear I thought “delete the database”. But where ......

If you google for “SQL Server 2008 Management Studio Express” you will find a MS resource which downloads a 172MB setup. But this setup does not offer a separate “SQL Server 2008 Management Studio Express” option. Why ever. So i startet a new search and i found this solution: Download & install the web platform installer Start the installer and use the “customize” link in the Database section to activate “SQL Server 2008 Management Studio Express” ......

Zum Testen meines BizTalk-Adapters für unsere Intranet-Datenbank musste ständig die Mitgliedschaft des BizTalk-Host-Accounts in der Standard-Datenbank-Rolle db_datawriter geändert werden. Über das GUI im Management-Studio macht das auf Dauer keinen Spaß. Aber mit den entsprechenden Stored Procedures (sp_addrolemember und sp_droprolemember) gehts ja auch. 1: USE IntranetDb 2: EXEC sp_addrolemember 'db_datawriter', 'DEV\BTServiceHost' 3: 4: USE IntranetDb 5: EXEC sp_droprolemember 'db_datawriter', ......

Beim Debugging wird der Fehler: "EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'." geworfen. Komplette Fehlermeldung: [System.Data.SqlClient.SqlE... = {"EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'."} Ein Deaktivieren der Checkbox "Enable SQL Server debugging" brachte keine Besserung. Eine dedizierte EXEC-Rechtevergabe für den Serviceuser BTServiceHost auf die Stored Procedure "sp_sdidebug" in der Datenbank "master" löste ......

Beim Installieren des Enterprise Single Sign-On Dienstes kommt folgende Fehlermeldung: The database server you specified cannot be reached. Make sure you have specified the correct server name and that the server is currently running. Login failed for user *** Die Domain-Gruppe der "SSO Administratoren" muss in die Gruppe der lokalen Adminstratoren auf der SQL Server Maschine. Der Installations-User bekommt durch die Mitgliedschaft in "SSO Administratoren" dann Admin-Rechte im SQL-Server ......

Wenn ein Remote-Zugriff auf einen SQL Server 2005 mit der Fehlermeldung "A connection was successfully established with the server, but then an error occurred during the pre-login handshake.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." scheitert, dann hilft folgendes Öffnen der SQL Server Surface Area Configuration Anwählen von "Surface Area Configuration for Services and Connections" Unter ......