Configuring Database Mail In SQL Server 2005
Aug 20, 2007
Hi
I have created profiles in my database as mentioned below. now i want to delete the profile created in database.
can some one tell me how to proceed furthur.
i need to delete them permenantly.
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'MyMailAccount',
@description = 'Mail account for Database Mail',
@email_address = 'makclaire@optonline.net',
@display_name = 'MyAccount',
@username='makclaire@optonline.net',
@password='abc123',
@mailserver_name = 'mail.optonline.net'
-----------------------------------------------------
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'MyMailProfile',
@description = 'Profile used for database mail'
--------------------------------------------------------EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'MyMailProfile',
@account_name = 'MyMailAccount',
@sequence_number = 1
-------------------------------------------------------EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'MyMailProfile',
@principal_name = 'public',
@is_default = 1 ; Regardskrishna
View 4 Replies
ADVERTISEMENT
Nov 7, 2007
The following installation:
- Microsoft SQL Server 2005 Standard Edition running on Microsoft Windows Server 2003 Standard Edition
- Client Service for Netware installed.
- Access 2000 database in a Novell Directory Services (NDS) Environment
- SQL Server service running under local Administrator account.
Linked server configured as follow:
Linked server: MyDB
Provider: Microsoft Jet 4.0 OLE DB Provider
Product name: Access 2000
Data Source: UNC path to my Access database
Security: Admin with no password (default Access behaviour)
I can connect to my access database by following the next steps:
- Open Management studio on the SQL Server itself (where I'm logged in as Administrator)
- Connect using Windows Authentication (Administrator)
- Create a new query, run EXEC sp_tables_ex 'MyDB'
This will return all the tables from the Access database.
I can also make a view pointing to MyDB...MyTable.
Enough prove to me It can work....
So far so good
But now the tricky part.
When I login as 'sa', I can't connect and will receive the following message:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyDB" returned message "'Full UNC to my access database' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.".Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyDB".
(In real life I want to connect to my SQL 2005 Server from a ASP.NET (2.0) application using SQL authentication, but as long as I can't get the above working this is not important for now)
View 3 Replies
View Related
Jul 23, 2005
I would like to configure e-mail alerts on my SQL Server 2000 box.However, we also run Exchange on the same machine. I've been told therecould be conflicts/issues having Outlook on the same machine asExchange; and apparently, one needs Outlook to configure a mail profilefor SQL Server Agent.Is there, in fact, anything to worry about? If so, are there anywork-arounds beside moving Exchange to another server? (we've only gotone server, so this is not an option for us at this time).Thanks.- Dana
View 1 Replies
View Related
Jun 18, 2001
Hi all,
I want to configure my SQL mail. I am able to configure SQL mail when i run the SQLAgent and SQL Server services under domain account for which Mail box was created in MS Exchange server. Also it works fine. But i want to Configure SQL mail without using Domain account (dont want to run services under domain account due to security reasons).
Anybody know how to Configure SQL mail without using domain account or is it possible to configure like that? Your suggestions are highly appreciated.
thanks in advance.
regards..
View 5 Replies
View Related
Aug 4, 2005
Hi All,My question is that can I configure SQL MAIL, if my EXCHANGESERVER is on different domain and my SQL is running on differentdomain.Can anyone guide me for this because I googled a lotwithout any result.I am using SQL SERVER 2000 Enterprise Edition with service pack 3.and MICROSOFT EXCHANGE SERVER 2000.ThanksT.V
View 1 Replies
View Related
Sep 27, 2006
wasnt sure which forum to put this in - so i'll attempt here!
i have been trying to setup SQLMail in SQL2000 but have been having a few problems
i have created an Outlook MAPI profile for SQL to use. i have tested the profile and it is sending emails - the profile was created using the correct user which has local admin privileges and also a domain account
i then assigned this profile to SQLMail within Enterprise manager and clicked Test. this completed successfully stating it was able to start & stop a MAPI session.
so i assumed that was all thats needed??
through Query Analyzer i run a simple test
EXEC xp_sendmail 'Craig.Gamble@<mydomain>.com' 'The DB is full'
i get a success message saying SQL mail sent. but it doesnt appear to send anything? i never recieve anything. The sent items does not contain anything and even when checking the actual Exchange server there is no sign of any mail being sent
i also checked the SQL account permissions to make sure it could access the Exchange Server using the
EXEC xp_cmdshell 'NET USE \EnterpriseIPC$' and again this returned success
so now im stumped!
is there anything else i can check to see where or what its supposedly sending??
any help greatly appreciated.
Cheers,
Craig
View 1 Replies
View Related
Feb 9, 2006
Hello, hoping someone might be able to help.
I've set up Database Mail on an instance of 2005 and the test mail works just fine. However, when testing a job (notify on fail, success, whatever) the mail fails to send. Job History last information reads NOTE: Failed to notify 'My Name' via email.
Checked out the Database Mail logs - nothing interesting.
Restarted the Agent service and then checked out the current Agent Log. Found message:
[260] Unable to start mail session (reason: No mail profile defined).
The 'DatabaseMailProfile' key is most certainly defined in the Registry
(at 'HKEY_LOCAL_MACHINE', N'SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1SQLServerAgent')
I'm at a loss...why is it telling me no mail profile defined?
I'd be most grateful for any help if anybody else has run across this problem.
Cheers,
Megan
View 2 Replies
View Related
Feb 25, 2008
Hi all asp.net 2.0 users,
I want to send the mail to the users of my system when there is any changes in the database or when i assign any user to the project giving them the information about the changes or asignee.
For this first i have to configrue Database mail in the SQL Server 2005. I tried this by going to the SQL Server 2005 Management Studio -> Object Explorer -> Management -> .............but there i donot find the Database mail option.
Again i went to the configuration tool -> SQL Server Surface Area Configuration
-> Surface Area Configuration....and there I enabled database mail.......
But still I have a problem of getting Database mail Option Object Explorer -> Management -> .......
I have been using SQLServer2005_SSMSEE for this as this is windows installer package.....what is the problem
I am tried for searching this..........and its very important for me.....
Will please help me in this condition its very urgent.....
View 1 Replies
View Related
Apr 3, 2007
How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?
View 1 Replies
View Related
Dec 4, 2006
Hi all,At this moment I'm trying to get database mail working. According tosome people it should be easy. Well...that is not the case for me.I'm having the following error:The mail could not be sent to the recipients because of the mail serverfailure. (Sending Mail using Account 2 (2006-11-24T08:48:15). ExceptionMessage: Cannot send mails to mail server. (Command not implemented.The server response was: Command not Supported).)SQL Server 2005 is installed on a separate server and the SMTP Serveris Lotus Notes. connecting with port 25.Start and stopping the SQL Server and SQL Server agent i tried already.i tried sysmail_stop_sp and sysmail_start_sp.Sometimes when starting or stopping the Mail with the followingcommands :exec sysmail_stop_spGOexec sysmail_start_spGOI will get the following error:Msg 233, Level 20, State 0, Line 0A transport-level error has occurred when sending the request to theserver. (provider: Shared Memory Provider, error: 0 - No process is onthe other end of the pipe.)So any help would be appreciated.Hennie
View 1 Replies
View Related
Sep 14, 2007
We have our SQL Server 2005 hosted at a datacenter and have only SS Management Studio access (no term serv, no event log, etc.). Also, our hosting company has disabled the Database Mail feature. We have over 60 jobs running on a minute/hourly/daily basis that are critical for our business. It is super important for us to know if and when a job failed.
Given this scenario, how do you suggest we implement monitoring/notification of failed jobs?
View 10 Replies
View Related
Feb 20, 2008
Hi all....
Our company use yahoo business mail server for our corporate mails. I know that I can configure database mail with SMTP. But when I try to configure database mail account with yahoo bizmail, I cannot do that. It gets configured but when I test it it doesn't send any mails. Do I need to have any special condiguration for this. SMTP address is smtp.bizmail.yahoo.com. Also I have specified the Authentication using my user name and password. Please help
Thanks
Rajesh
View 10 Replies
View Related
Dec 21, 2006
Attempting to link Access 2003 to SQL 2005, there is something keeping from doing so.
1 I setup the instance as sqlexpress.
2 I have a database shell there also.
3 It connects when I start the instance service.
4 My remote connections are configured to handle TCP/IP & Named Pipes.
Not in this order, but you get the idea. Now that I have these in place, I went first to the Access 2003 database to link the tables to this. When I came accross trouble in the form of need for a DSN to the domain for the things I created above.
In attempting to create one that looked functional, I came back to the same step. But, unsuccessful to link the tables again because browsing to that domain does not even show that particular file. This is the problem.
I do believe that once I am able to select a DSN, I will have a "healthy baby connection". I will then be the proud father of my first Server-side database setup!!!! But I am trying to get over these labor pains.
View 1 Replies
View Related
Nov 19, 2007
Hello everybody!
I'm trying to configure a ReportServer in a Non-DefaltWebSite in my server. During the Reporting Server Configuration's process, everything works fine! All the informations are accept. But, when I try to access the address http://myserver.com/reportserver (or http://myserver.com/reports) a login message box is shown.
I've already tried to enable a lot of user accounts, but with no success!
I've read some articles that try to explain how to install a ReportServer in a Non-DefaultWebSite, but its doesn't work too.
Any sugestions?
My server is a Windows 2003 Standard Edition w/ SP1, IIS 6.0, SQL Server 2005 Express Edition Advanced Server.
Regards,
Jorge Olimpia
View 1 Replies
View Related
Mar 3, 2008
after i installed sql server 2005 DM add-ins, i tried using it with office 2007 so i choose (start---->all programs----->microsoft sql 2005 dm add-ins---->getting started) so the getting started wizzard was opened, i selected from it (use an existing instance of microsoft sql server 2005 analysis services that i adminster) because i already had a version of it installed on my computer. then i tried to connect to analysis services by selecting 'server name'=local host, an error appeared which is "unable to discover meta data on the server 'local host' . user noha needs to be adminstrator of the server to run the configuration tool". how can i be the adminstrator of the server?????????.........plz reply me soon,thanks in advance
View 6 Replies
View Related
May 25, 2008
Does anyone have instructions on how to configure http access to SQL Server 2005 Analysis Services on Vista?
View 5 Replies
View Related
Feb 4, 2007
Visual C# 2005 Step by Step €“ John Sharp
Intel D975XBX €“ 930 €“ 2GB ram €“ HD 300GB - MatroxVD
Windows XP Sp2 + updates
Visual Studio 2005 Professional edition
SQL Sever 2005 Standard Edition
20070203
Install Practice Files at D:Program FilesMicrosoft PressVisual C Sharp Step by Step.
Configuring SQL Sever Express Edition
Hostname - xxxxxxxxx..
At sqlcmd €“s xxxxx...SQLExpress €“E got - Pipes error.
Open Microsoft SQL Sever 2005 - Configuration Tools €“ SQL Configuration Manager €“ select Protcols for SQLEXPRESS €“ select Named Pipes €“ enable €“ close.
At sqlcmd €“s xxxxx..SQLExpress €“E get Sqlcmd: €˜ €˜ : Unknown Option. Enter €˜ -? €˜ for help.
Chdir C:Documents and SettingsAll UsersStart MenuProgramsMicrosoft Server 2005
Sqlcmd €“s xxxxxx..SqlExpress €“E
Hresult 0x2, Lvel 16, State 1
Named Pipes Provider: Couldnot open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : 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..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
How do I fix this?
Need to be able to to use the Northwind Traders data base
Thanks
View 1 Replies
View Related
Apr 7, 2008
I have configured sql 2005 to send Database mail via SMTP using a profile and account that works fine during a test send. However, when I set myself up as an opperator (with the same email as the test) and tell a job to email me upon sucess, and run the job I dont get the email.I looked at the error log, and get the error that: "an attempt was made to send an email when no email session has been established"Any help is greatly appreciated!Dan
View 2 Replies
View Related
Jan 24, 2008
I recently got the datamail setup and running. I am able to use database test mail to successfully send a test email relay through the SMTP port of the exchange server and then out to the appropriate email adress.
When i use the SP_Send_Dbmail it says Mail Queue. I check the sysmail_allitems it says the Sent_Status is sent but I never receive it.
Everything below executes just fine and places the right information in the right msdb tables. I just never receive the email. Any suggestions on where to look? Service_broker messages is enabled and i restart sqlserveragent also.
use msdb
go
exec msdb..sysmail_start_sp
go
EXEC msdb..sp_send_dbmail
@profile_name = 'DBuser'
@recipients = 'user@yahoo.com',
@subject = 'Test',
@body = 'Test',
@body_format = 'HTML'
View 1 Replies
View Related
Aug 7, 2006
I thought I knew.
Under SQL 2005 SSIS I can successfully send email (using their SNMP task). So I thought that was database mail. But the other day I started reading about Database mail and setting up profiles and it had nothing to do with SSIS tasks! So what is it all about?
TIA,
barkingdog
View 1 Replies
View Related
Jan 29, 2007
I'm Getting "Report Server WMI Provider error: Not Found" when trying to Grant Database Access while configuring the Reporting Sevices Integration. Logging in fine to the DB. Tried all the WMI troublshooting and can't find any issues there. Any tips?
Many Thanks!!
View 10 Replies
View Related
Jan 25, 2008
I have setup database mail on my SQL 2005 server. It works fine. I am using it to send subscription mail. If the email addresses are good, it works fine. If there is a bad email address rather then skipping that email address, it shuts down and quits the rest of the process.
Is there a way to configure it to log the error and move on? With SQL 2000 all it did was toss it into a queue and hope. The SMTP server dealt with the problems. Now it seems Database Mail is determining there is a problem and giving up.
While I love the new sysmail tables that allow me to track what happened, I hate the fact the the system decides if is too frightened by an error and it needs to runaway and hide. [:D]
Also, does anyone know of a good resource for describing the sysmail table relationships?
Thanks in advance for the help,
Thom
View 2 Replies
View Related
Jan 24, 2008
I have setup database mail on my SQL 2005 server. It works fine. I am using it to send subscription mail. If the email addresses are good, it works fine. If there is a bad email address rather then skipping that email address, it shuts down and quits the rest of the process.
Is there a way to configure it to log the error and move on? With SQL 2000 all it did was toss it into a queue and hope. The SMTP server dealt with the problems. Now it seems Database Mail is determining there is a problem and giving up.
While I love the new sysmail tables that allow me to track what happened, I hate the fact the the system decides if is too frightened by an error and it needs to runaway and hide.
Also, does anyone know of a good resource for describing the sysmail table relationships?
Thanks in advance for the help,
Thom
View 6 Replies
View Related
Feb 19, 2008
Mail is getting 'stuck' in the unsent state. When I send a test mail or notification - the mail ends up in the sysmail table. If I manually double click on databasemail90.exe the email will be sent but for some reason this app is not being fired off automatically. I have tried disabling and re enabling service broker on msdb.
Running the following queries I get
SELECT * from sys.dm_broker_queue_monitors - no results.
SELECT * from sys.service_queues - expected results
InternalMailQueue 843150049 NULL 1 0 SQ SERVICE_QUEUE
ExternalMailQueue 875150163 NULL 1 0 SQ SERVICE_QUEUE
QueryNotificationErrorsQueue 1977058079 NULL 1 0 SQ SERVICE_QUEUE
EventNotificationErrorsQueue 2009058193 NULL 1 0 SQ SERVICE_QUEUE
ServiceBrokerQueue 2041058307 NULL 1 0 SQ SERVICE_QUEUE
View 13 Replies
View Related
May 8, 2008
Hello, I've been banging my head trying to figure this one out so I appreciate any help you guys can provide.
I've setup and configured SQL 2005's Database mail and have sent a few plain and simple text emails and I receive it fine at the destination.
I now want to send mime messages but I'm not sure what I'm doing wrong. I took the following source from an email that linked-in sent me which was a mime message:
"
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary='----=_Part_434343432'
------=_Part_434343432
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Plain Text Goes Here
------=_Part_434343432
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<html>
<body>
<b>HTML Goes here</b>
</body>
</html>
------=_Part_434343432--
"
and put the above text in the @body parameter of the stored proc msdb.dbo.sp_send_dbmail and submitted it.
When I received the email, it didn't appear as html. Instead, I just got the mime message above as plain text in my email as if someone just typed it and sent it to me. What do I need to do for SQL Database Mail to send the above as a MIME message?
Thanks in advance for any help
View 5 Replies
View Related
Mar 7, 2007
Lokendra writes "I have configured the Database mail profile and account in Sql Server 2005 but the mail is not sending and showing the following error message:
Error,235,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-03-05T15:16:07). Exception Message: Cannot send mails to mail server. (Mailbox name not allowed. The server response was: Sorry<c/> that domain isn't in my list of allowed rcpthosts.).
),3000,90,,3/5/2007 3:16:07 PM,sa
but while in the same mail set up in previous instance of sql server 2005 the message was sending very well. After installing new instance of sql server 2005 the problem is arising.
Anybody can tell me that what I can do so that i can send mail using the SMTP databasemail account."
View 1 Replies
View Related
Feb 6, 2007
I am trying to migrate from my current system, where I do merge replication from Windows Mobile devices running SQL Server CE 2.0 to a central database running SQL Server 2000 sp3a. I want eventually to move to a system running SQL Server 2005 CE replicating to a SQL Server 2005 back-end. But the transition will need to be gradual, and I may have to support both systems for a while until I can convert all clients from the old system to the new. I also need to do thorough testing.
So ... I'm trying to set up a test environment giving me the maximum possible flexibility to do my testing. Ideally, I'd like to set up SQL Server 2000 and SQL Server 2005 on a side-by-side basis, in a manner that would potentially allow mobile devices running both SQL Server CE 2.0 and SQL Server 2005 CE to sync with either back-end server.
Can someone provide me with guidance as what is possible to set up here? I know that SQL Server 2000 and 2005 can be installed side-by-side on the same server. It also appears that you can set up SQL Server 2000 so that EITHER SQL Server CE 2.0 OR SQL Server 2005 CE can sync with SQL Server 2000 (see www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx), but I don't know if it's possible for BOTH SQL Server CE 2.0 AND SQL Server 2005 CE to sync to the same SQL Server 2000. As for SQL Server 2005 ... it appears to be possible to set up SQL Server 2005 so that BOTH SQL Server CE 2.0 devices AND SQL Server 2005 CE devices can sync to the same SQL Server 2005 (see web page cited above). However, I don't know if it's possible to set up a SQL Server 2005 server installation in this manner while at the same time having a side-by-side SQL Server 2000 installation supporting any level of mobile merge replication.
HELP!!!!
View 7 Replies
View Related
Sep 1, 2006
Hello
I have got a script which gives the mail to the dba mail box when database backup fails.
In the script I want to make a change so that I get the particular database name , on what ever database i implement.
Can you tell me some suggestions.
The script I am using is :
use master
go
alter PROCEDURE dbo.SendMail
@to VARCHAR(255),
@subject VARCHAR(255),
@message VARCHAR(8000)
AS
BEGIN
SET NOCOUNT ON;
DECLARE
@rv INT,
@from VARCHAR(64),
@server VARCHAR(255);
SELECT
@from = 'testsql2000@is.depaul.edu',
@server = 'smtp.depaul.edu';
select @message = @message + char(13) + Char(13) + @@servername + '-'+ db_name()+ '-' + 'Backup Status Failed' + Char(13)
EXEC @rv = dbo.xp_smtp_sendmail
@to = @to,
@from = @from,
@message = @message,
@subject = @subject,
@server = @server;
END
GO
--- After the above script is run the following should be given in the 2nd step when
--- the backup jobs are scheduled ------
exec master.dbo.sendmail
@to = 'dvaddi@depaul.edu',
@subject =' Test sqlserver 2000',
@message = '' ;
Thanks
View 4 Replies
View Related
Mar 9, 2007
Hi every body
I want to send a simple mail using DATABASE MAIL feature in SQL SERVER 2005.
I've defined a public profile.
I've enabled Database Mail stored procedures through the Surface Area Configuration .
but I can't send a mail with sp_send_dbmail stored procedure in 'msdb' database .
when I execute sp_send_dbmail in the Managment Studio the message is
"Mail queued" but the mail is not sent.
Could it be related to Service Broker?Because the Surface Area Configuration indicates:'this inctance does not have a Service Broker endpoint'.If so, how should I make an endpoint?
here is the log file after executing sp_send_dbmail:
1) "DatabaseMail process is started"
2) "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2007-03-08T00:49:29). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it)."
The DatabaseMail90.exe is triggred ,so the mail is transfered to the mail queue but DatabaseMail90.exe couldn't give the mail to SMTP server.The promlem is what should I do to make DatabaseMail90.exe able to connect to the server?
please help me.
POUYAN
View 21 Replies
View Related
Apr 30, 2008
hi,
Very New to SQL MAIL... SQL SERVER 2005....
I am trying to set sql mail for my SQL server 2005.. i m on client machine...from here i got info for @@version
Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
I have created alerts (TestAlert),operator (TestOperator.. here i have mentioned my email id)
I have created simple JOB ..insert statement...owner as NT AUTHORITYSYSTEM...under alert I assigned TestAlert..under notification I assinged or checked my TestOperator...click ok
I also checked in Service Area Configuration Features .. Enable SQL Mail Stored Procedures...
But when i loggned in Query Analyser as Windows Login and fired
EXEC xp_startmail I got error like
Msg 17930, Level 16, State 1, Line 0
xp_startmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
Also Under Legacy..SQL MAIL..when i right click I got error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
If a stored procedure could not be found, SQL Mail may not be installed in the instance. (SqlManagerUI)
------------------------------
xp_get_mapi_profiles: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. (Microsoft SQL Server, Error: 17930)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1406&EvtSrc=MSSQLServer&EvtID=17930&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
On my machine (its client machine) Outlook is configured but on server it is not....
Please suggest me best way to set SQL MAIL....I needed to set notification when any job executed as success....
T.I.A
View 6 Replies
View Related
Jul 26, 2007
Hi all
Can anyone help?
I have installed reporting services for 64 bit SQL and I am having a problem configuring it correctly so that I can access the reports manager on http://localhost/reports.
I have studied various SQL server 2005 bibles and looked at information on the microsoft support site but nothing seems to be helping me.
I get the impression that it could be a problem with the IIS server.
Can anyone give me a complete run down on how to set up and configure the reporting services so that it will actually work. Every step of the way please.
Thanks
Alex Oakley
View 5 Replies
View Related
Jul 7, 2007
hi,
I need to connect my Local Database from SQL Server to the Web Database.
I need to know what all things to be done for completing this process. Some one please please help me with this.
Ad if this information is not enough, please do ask me any question regarding this and iam ready to answer them.
One more thing, iam not that familiar with SQL Server 2000 but i can manage to do things.
So please do help me on this.
Clever_Idiot
View 4 Replies
View Related
Jun 9, 2006
I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is 'ASPNET' in "SELECT @s = @@servername + 'ASPNET'"
Also what is 'webuser'
---Configure Doctors
USE doctors
GO
DECLARE @s varchar(50)
SELECT @s = @@servername + 'ASPNET'
EXECUTE sp_grantlogin @s
EXECUTE sp_grantdbaccess @s, 'webuser'
GO
GRANT EXECUTE ON [getUniqueCities] TO webuser
GRANT EXECUTE ON [getDrSpecialty] TO webuser
GRANT SELECT ON [specialties] TO webuser
GRANT SELECT ON [doctors] TO webuser
GRANT SELECT ON [drspecialties] TO webuser
GO
Can anyone help me how to solve my problem?
Your help would be very much appreciated
Thanks and Regards
Kavitha
View 1 Replies
View Related