View Complete Post
Referring to this tutorial: http://www.asp.net/webmatrix/tutorials/download-and-install-an-asp-net-application
I selected umbraco cms and got this wizard:
I already have Standard Sql Server 2005 on my machine which I wanted to us for above DB and not SqlExpress.
I did not remember "sa" account pwd nor I use explicitly any account to connect to my Sqlserver. I use Windows Authentication account i.e implicit authentication. So I created new account and gave all rights and used it in the above wizard and was able to install the database after some struggle.
My question is: What if I want to use my Windows Account to install the database above? Why the wizard don't have any option to use Windows Integrated Authentication?
Note: I can create the DB with external user I created, just looking specifics for using Windows Authentication for above installation.
Im using Enterprise library 5.0I have a scenario, where I have to access two
different databases in my application.Basically this application is a
webservice,delployed on my local for testing purpose.I'm trying to access
this web method from diffent windows application, default connection works fine
but the other database throw's exception.Problem is only my
defaultDatabase is works fine, if I change defaultDatabase="MYCON1" with
"MYCON2" it works fine, if I try to access the other database which is not
default, throws exception.<dataConfiguration defaultDatabase="MYCON1"
connectionString="Data Source=server1;Initial Catalog=dbName1;User
I have tried dozens of changes and modifications to many settings as I will outilne here and all to no avail.
The short answer here though is that I uninstalled SQL Sever Express 2008 R2 and went back to the "NON" 2008 R2 and got things working. But like the fool I am wanted to run on the more current rev and updated again, all problems returned....
Win Server 2003 R2 SP2
SQL SERVER EXPRESS 2009 R2
VWD2008 Express (removed)
SQL Server Express 2008
I was orginally getting this message after updating to SQL Sever Express 2008 R2, I removed VWD 2008 Express from the web server, no good, then uninstalled SQL Server 2008 Express R2 and reinstalled SQL Server 2008 Express. worked but had issues, couldn't install MGTM Studio. Then I removed SQL 2008, cleaned folders and reg. Reloaded SQL Server 2008 Express, still flaky, couldn't get the Management Studio to install. So I removed it again and used the Web Platform Installer, which worked but loaded 2008 R2 again. Which brought back the message.
Failed to genera
Instance management refers to a set of techniques used by Windows Communication Foundation to bind a set of messages to a service instance. This article introduces the concept and shows you why you need instance management.
MSDN Magazine June 2006
MSDN Magazine September 2005
I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005.
I am connecting to a SQL Database from VS 2005, Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True.
The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False.
I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working.
Appreciate your help.
I have succeffuly Imported the ADF and have also successfully created a Business Data Column. But when I try to query data , I get the following error
An error occurred while retrieving data from Oracle Instance. Administrator, see the server log for more information
And this is what I found in the Application Logs
A Metadata Exception was constructed in App Domain '/LM/W3SVC/81256521/ROOT-1-129217212004078822'. The full exception text is: LobSystem could not be found using criteria 'id=476'.
I have a problem w/ a web app which is probably fairly common, but I cannot find any solutions anywhere. Hopefully someone will have an idea.
The web app in question provides a UI for editing a client (in the business sense, not the browser sense), identified by a ClientID. I store the ClientID in Session, which gets passed from page to page, along with a number of other pieces of data in Session. Works great.
The problem is that if the user opens a new browser window using Ctrl N or File->New Window (in IE), the new window comes up with the same page as the current page, with the same session info. Then if the user navigates to a different client in the 2nd window, the ClientID in session refers to the new client. If they go back to the original browser window and save, the original client gets saved using the 2nd ClientID, and all hell breaks loose, because now the data from the two jobs are intertwined.
I have enabled trace and verified that the new browser window uses the same SessionID as the original. If an entirely new instance of IE is opened, it has a different SessionID, so is not a problem. I have not yet investigated other browsers, such as Chrome or Firefox.
Is there any way to determine if a browser instance is opened for a web app which is already open in
I am working on a website which uses a common database shared by another 2-3 websites. Now i am having a requirement that whenever a user clicks a link provided on another website and comes to my website and if the user is already logged in to my website then my website should not ask him to login again it should by pass the login page and show the next page.
Here the problem is i am not able to get the session objects in newly opened browser window even if the user is already logged in to my website in another browser window. I am not sure but i thing IE uses two different processes for two different browser instance and because of that i am not getting the session objects required.
Deos anyone have some idea on my problem.
Note: I can not ask the another website vendor to pass anything as a querystring.
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
My requirement is that i upload an excel file then i need to validate that data.
1. Uploading file using using upload control saving binary in SqlServer
2. Then i am creating file from binary data on Sql Server using below command and then using OPENROWSET to dump data to Sql table
3. Then reading Sql Table row wise and validating data.
Alter Procedure spUploadExcelFile
Declare @VarBin varbinary(max)
Declare @FileName varchar(100)
DECLARE @sql nvarchar(MAX)
DECLARE @errMsg nvarchar(MAX)
DECLARE @ObjectReturn INT
DECLARE @ErrorSource VARCHAR(255)
DECLARE @ErrorDesc VARCHAR(255)
DECLARE @ObjectToken INT
Select @VarBin = Content , @FileName = [FileName] from MultilangBinaryData Where PKID = @PKID
SET @FileName = 'C:\' + @FileName
EXEC sp_OACreate 'ADODB.Stream' @ObjectToken OUTPUT
EXEC sp_OASetProperty @ObjectToken, 'Type', 1
EXEC sp_OAMethod @ObjectToken, 'Open'
EXEC sp_OAMethod @ObjectToken, 'Write', NULL, @VarBin
EXEC sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @FileName, 2
EXEC sp_OAMethod @ObjectToken, 'Close'
EXEC sp_OADestroy @ObjectToken
SET @sql = 'INSERT INTO dbo.UserBulkData SELECT 0,NULL,'+ @BatchI