in its webconfig file i have
<identity impersonate="true" userName="webserverloginname" password="webserverpassword" />
sername1= username of the system
password1 = passowrd of the system
username2= username of the the database
password2 = passowrd of the database
client system which access the database server aswell as web server
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 14, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'BILL'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
i have both sql2000 & 2005 on my system
i want attach tha database in sql2005.
if in case the database was mad ein sql2000 how do i attach in sql2005
or wht can be done??
Reposting my unanswered in technet.microsoft question?
MSDN "ASP.NET Delegation" article tells:
1) "When you configure to use a particular account as the process identity, ASP.NET attempts to delegate that account. If it is a local account that is identical (including password) to a local account on a remote machine, delegation is possible. If such an account does not exist on the remote machine, to the network it appears as the Windows anonymous account (NT AUTHORITYANONYMOUS LOGON). In addition, delegation is also possible if the account is a domain account that has access to the remote machine, in which case it uses the domain network identity of that account."
The same frequently repeated story as in case of manually/interactively accessing remote computer (server resource) in workgroup - it is necessary to create local account with the same username, the same password. But why?
If a workgroup Windows client process cannot access resources on server machine without having duplicate of such (local) account on target machine already pre-created,does it mean that client (process, machine, or user) can access server resources only by/after having logged (opening logon session) into server machine? Or, how to understand that such access is impossible without having corresponding duplicate local account on server machine?
The same MSDN "ASP.NET Delegation" article tells:
"NetworkService account. It behaves the same as the System account. This account possesses the network credentials associated with the machine account (domainnamemachinename) in the domain of which it is a member"
Does not any Windows have accounts ((NT AUTHORITYNETWORK SERVICE)? as well as many other common pre-built accounts? Why are they installed (before any joining to domain) but cannot be used for remote network access and client identification ? And what is identity used when the process from workgroup Windows under identity ((NT AUTHORITYNETWORK SERVICE) accesses a remote server?
My related questions:
domained LocalSystem vs. non-domained LocalSystem account in Windows-es ? how to check group membership of an "NT AUTHORITY" account ? Is client LocalSystem (SYSTEM) identified by target/server machine? and in which context? Window workgroup LocalSystem vs. domain (AD) LocalSystem [closed]how to better set up machine for development both in workgroup and Windows domain? [closed] interoperating with Windows domain computer from workrgroup Windows [closed] the context of local user of AD-joined machine? Is it of domain machine account or of local machine account? RunAs under domain account from non-AD Windows [closed] how to better set up machine for development both in workgroup and Windows domain? [closed] how to share the same domain machine account with multi-boot workgroup Windows setup?
i want to take the DB Backup from theremote server to the local system..
i'm using sql server2008 enterprise edition and the remote server is sql server2008 express. how to do it..
When am using below code it's working fine on my local host but when am host on server getting error.
Response.Write("sam "+System.Net.Dns.GetHostEntry(Request.ServerVariables["REMOTE_HOST"]).HostName);
Error:
The requested name is valid, but no data of the requested type was found.
I have SQL Server 2008 R2 Express and Visual Web Developer 2010 Express installed on my PC.I want users to login to my site and add listings that must be linked to their username. ASP.NET generates the ASPNETDB.mdb file when using login / membership function.How do I access this database from SQL server 2008 R2 Express ?
How do I link this database to my own SQL express database?
I m uploading file to a directory inside my website root directory like this-
[Code]....
I m getting exception-
System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:Documents and SettingsAdminMy DocumentsVisual Studio 2008WebSitesElcomponics Sales-BDsamples�50841010_sd113201031833.pdf'.
Why so?
When i deployed my app on server and accessed it from client system. It is not throwing exception.What is the difference?
Still i want to confirm will it throw the same exception in case i deployed it to server and access it from client.
I am applying a field validator on a listbox which works when no item is selected in the textbox and some(most often the submit button) control is made to postback to the server.Now the problem is that if a person has entered the page and want to logout it still gives the same exception messages(which it should) rather than logging out of the page.I am using ASP.NET with c# as back-end.I want the the logout button(rather all except the submit button) to function prior to the validation
View 1 Replieshow can i access client machine's specific file contained in a drive or folder.Suppose in Server side i have knowledge of full path of a file that is present in client side, like "D:ABCFolderxyzFile.doc", this is a file that i want to retrieve and store in server side .
View 8 RepliesHow can I access server side functions from the HTML code? See the following code:
<a id="Taggloud" runat="server" class="lblTagCloud" onClick="TagOnCloud_Click">click</a>
Here I'm calling the tagonCloud_click function that's defined in server side(code behind). How can i call that function?
i am using a div in the top of the master page which have the controls for login. When the user succesfully login to the application the visibility of the div should be hidden. can i achieve this is in server side.
View 2 RepliesI want to Access remote server( ie., want to access online server not local server) in my Application.. I change Settings in SQL surface Area Configuration---> Remote Connection ( checked the Local and Remote Connection ) Then while running the application it showing the following error.(I make off the firewall also) 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)
View 1 RepliesWhat is Web services? What is Web services? How can I Transfer the data from server to client and  client to server using XML. Need one simple Example program(C# web Application) ...
View 1 RepliesI want to access oracle database which is on diffrent server my application is giving error in connection string that is object ref not set
View 1 RepliesI have a simple update query to a access database. Works perfectly on my localhost but when I upload it to the server it displays this. The weird thing in the "
monstababy.MailingList.btnSubmit_Click(Object sender, EventArgs e) in C:inetpubwwwrootmonstababymonstababymonstababyMailingList.aspx.cs:26" mention of my
local host settings on the server. I have spoken to my host and they have set permissions for the data folder etc but this still prevails. I am positive it
Source Error:
[Code]....
Stack Trace:
[Code]....
So far I've done a table with six rows, each has either a label or a textbox controller inside. The fifth, however, has a button controller inbedded in the cell.
According to my course literature I also need a login controller to be able to use the registered accounts that I created using WAT.
On the page 746 in Beginning ASP.NET 3.5 in C# 2008, they show how a login controller should be written.. Is there a way to take my already completed label and textbox controllers and place them inside this login controller or do I need to replace what I've created so far with this login controller? Or can I just keep what I've created and not use the login controller?
Even if my code looks like this (aspx):
[Code]....
and my code-behind:
[Code]....
It still doesnt wanna let me login. It's like the cmdLogin_Click-method doesnt even get called.. it's like I press the Refresh button in the browser..
I would like to identify users that connect on a intranet web server (IIS) with client certificates.
I've set up a CA server on a Windows 2003 server pc. On my development pc, i've a windows xp with a web server (IIS) running.From my web server, i generated a certificate request (i specified the netbios name of my web server because this setup is for an intranet), i used that request to generate a web server certificate and i installed it on my IIS to allow SSL connection. . Now, i can connect with https to my web server from an internet explorer. I configured the web server to 'require client certificates'.
I would like to authenticate the users with a client certificate installed on each users pc. My CA server allows users to request a client certificate (domain user) from the CA server just by typing the url of the CA server and click 'User Certificate', 'submit' and then 'Install this certificate'.
In order to test my setup, i opened a Internet Explorer from a pc which resides in the domain and i requested and installed the user certificate. Then i connected to my web server and i get a window with the title "Choose a digital certificate". This window is always empty and never proposes the client certificate i previously installed on the user pc.
I've no idea of what i missed during my setup. I'm still wondering how the browser knows how to select which certificate must be displayed according to the url typed in the address bar.
I have an ASP.NET site on Windows Server 2008 (with is domain controller) and IIS7. The site is in a Pool which identidy is "ApplicationPoolIdentity"
I need to allow the user on my site to execute Schtasks.exe whith some arguments. but this doesn't work whithout error message.
I am sure it because user right, I won't to change the ApplicationPoolIdentity to "LocalService" or "NetworkService".
I try to launch Schtasks.exe whith code like this :
[Code]....
what is the best way to allow asp.net application to execute EXE on server with the minium right. ?
Created a windows service for my local system for sending bulk mail and it is working.But the same if the want to access the db which is there in hosted server and want to install it in my local machine to access the db details from the server , is not working. While starting a service , it is stopping immediately. Is it possible to do so?
View 1 RepliesI have SQL Management studio in one system. It has lot of tables, stored procedurs. I want to move that database data into another system. like taking Office database to my home. How can I do that ?
View 1 RepliesI am trying to get data from reporting server and show it to client .
string url = "http://reports/ReportServer/Pages/ReportViewer.aspx?%2fLNA1123 - Repayment receipt (KB Subs)&P_REPAYMENT_DATE1=7/7/2010&P_GR_ACC_NO1=123123123&P_CLIENT_NAME1=els&P_BANK_CODE1=bank&P_BANK_ACCOUNT1=1212&P_BANK_BRANCH_NAME1=123&P_CREDIT_AMOUNT1=11&P_AMOUNT_IN_WORDS_CR1=asdasdasd&rs%3AFormat=MHTML";
I am using SQL server 2008 . What i all want is to create a uses that can only see the ABCDatabase in Management studio onced login. And to achieve that:
1- I have created a new user.
2- Deny View all database right to that user.
3-Set that user as Owner of ABCDatabase
Now on login that user cannot see other databases but still able to see the system databases. How can i hide those system databases from that user?
i have to copy AI file from client machne toserver without use the file upload control.
Can i use Scripting.FileSystemObject ?
I have an ASP.NET application that was working fine on my server up until last night when I installed a bunch of windows updates, now it's throwing this exception : System.Security.SecurityException: Requested registry access is not allowed.Unfortunately there is some things that makes this hard to debug. I added the debug="true" attribute to the web.config file to get the line where the exception is lauched. The line identified in my code is an End If and the code just before seems benign :
<body id="body" runat="server">
<div class="conteneur-confirmation">
<%
[code]...
i would like to update database which resides on web server from my database which is on my computer. One method is to upload the file and than make a connectionstring. But its not possible while I do so in every 10 secs.
Is there any method which can make the connection string from desktop to web server or any other way.