SQL Server 2005 DatabaseMail
Jun 23, 2007
A client of mine took over a website and transferred it to a new server. It uses SQL Server 2005. It is coded in VB/asp.net and I have all of the web content but not the original vb source. I thought everything was working, but an important part of the site apparently uses databasemail and is hard coded to use a particular profile.
Sooo.. I setup Database Mail, enabled it, created a profile and mail account, tested it, etc and got it working just fine. However, the website is trying to use a particular profile name and I have no clue what it is. My client is unable to get in touch with the former owner of the site at this point either due to political reasons. Therefore, I am getting this error:
System.Data.SqlClient.SqlException: profile name is not valid profile name is not valid at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at RER.signup.subAddContact() in C:UsersDusanVSWebCache....etc
I tried guessing obvious profile names. I tried running Network Monitor, but it can't capture the raw SQL queries due to it being a local SQL server. I looked into SQL Profiler, but I am running Workgroup Edition of SQL Server 2005 so it is not included. My next idea is to maybe place the database on a remote machine and have the website connect to it remotely so I can snoop the network traffic and maybe pick up the profile name. That is going to be a big pain however.
Does ANYONE have ANY suggestions on what else I can do to pull this profile name? Is there some way to trick SQL server into accepting a wildcard for a profile name or SOMETHING? It is such a minor issue and I feel like it should be a lot easier to solve than it has been!
View 0 Replies
ADVERTISEMENT
Oct 5, 2009
I have built a website based off of The Beer House template/book and am about ready to launch it. I need SQL server 2005, and ASP.net functionality. I will either use the included forum module or am considering a third party forum such as aspplayground.net.
I would like to spend $10-$20/month, I don't mind paying a bit extra to have a fast loading site, but I don't want to spend too much. I would appreciate any suggestions.
The database will handle the forums, the store, the users of course, and a custom database I am building for some vehicle information. To start out the database is not very big (maybe 20mb), but I expect it to grow to support the forums and users, etc.
Also, I have already built a database (mdf) file on my computer through visual studio 2008. Is it true most shared hosting accounts wont allow you the access to copy and paste the database file directly? I don't really want to have to recreate all these tables on the host server.
View 14 Replies
View Related
May 5, 2008
I have a sql server 2005 database which is 5gb. My current host only allows 2gb and charges and obscene amount for extra space. Does anyone know of an inexpensive host that I can put a 5gb database 2005 on? It doesn't need much bandwidth, it will just be for storage/archive purposes.
View 6 Replies
View Related
Mar 1, 2007
Just wanted to know how prevalent VS 2005 is now. We are basically virtualizing everything that moves as it is easier to upgrade to a new server and move the VPS around. Also we get to control the reboots etc.
View 12 Replies
View Related
May 1, 2007
I recently signed up with cartikahosting.com only to find out they do not support SQL server 2005 when I tried to install my application.
Their features and price are excellent so I would like to stay with cartika if possible, is there a way to convert my database to 2000? Or backup the database using sql server scripts?
View 4 Replies
View Related
Mar 21, 2007
I bought Windows Vista Ultimate OEM and installed it on the physical machine, can I install Virtual Server 2005 and install the ultimate OEM version again on the VIRTUAL server 2005??
I run MySql but I hate to run it on the physical machine, want to run on a virtual machine.
View 3 Replies
View Related
Nov 26, 2008
asp.net 2.0 + mssql server 2005 + ajaxtoolkit support
I need windows hosting with asp.net 2.0 + mssql server 2005 + ajaxtoolkit support for a website project that is being developed. It can probably be launched on shared hosting, but I would prefer at least a VPS. With any success this site would eventually need to be hosted on a dedicated server.
I have been offered a 1U Dell server for free with Windows Server 2003, Dual Xenon Processors, 2 GB ram and 2 x 80gb hard drives. It would probably serve the site well for a long time, but I would need to set it up (or get it setup $) for the above requirements and get it colocated somewhere. BTW, I'm not too familiar with Windows hosting.
To launch the site, I don't really want to spend more than $100 per month. And I'd prefer to stay in the $50 per month range if possible.
Open to any and all suggestions, comments, questions at this point? I've searched and see a lot of suggestions for shared hosting, but I'd really like your opinions on colocating the dedicated server.
View 4 Replies
View Related
May 8, 2007
We use VS 2005 and are happy with the stability and performance etc but wanted to know if there are any great advantages to using virtuozzo? It seems that a higher ratio of VPS per box can be achieved with virtuozzo due to the ability to share RAM but is this worth it for the extra cost of licenses and possible security / stability risks?
View 0 Replies
View Related
Jun 5, 2008
I got some question regarding MS virtual server2005 R2.
1. If i created an instance of Windows2003 in virtual server2005, if i screw up something. would it affect or crash my host server? I have a colo Windows2003 R2 standard server but it also host several websites that i don't want it to go down if i mess up the instance in vs2005. i believe it won't affect the host but i just want to confirm this. does anyone have problem with screw up guest OS taking down the host OS?
2. how about liscense? do i need to purchase an liscense of Windows2003 in order to run in virtual server?
3. how much RAM do you think i need to assign to it? my colo server spec. is AMD64 dual core 4000+ w/4GB of RAM. Do you think 512mb is good enough for the guest OS (windows2003).
View 1 Replies
View Related
Nov 17, 2008
I was trying to bring down license fee for a customer who needed SQL Server on Windows Server.
realised that MS has released a fix to install the SQL Server 2005 on a Windows 2008 Web Edition.[url]
The license fee for the web edition is lower than the standard version.
View 3 Replies
View Related
Jun 20, 2008
Do you know is Microsoft Virtual Server 2005 R2 really free? By this I mean can I start VPS hosting business using Microsoft Virtual Server 2005 R2 without paying any license fee for virtualization product? Are there any restrictions?
I was very unpleasantly surprised when I found out that VmWare Server is actually not free and totally unusable for VPS hosting companies, although when you read their FAQ you get impression that its free and that ESX is just "better version". In fact for VPS hosting VmWare is not free and its totally useless.
So I am interested if there is some "minor glitch" in Microsoft agreement for Virtual server as is in VmWare agreement for VmWare Server?
View 9 Replies
View Related
Jul 24, 2008
After carefully choosing a VPS Host, I decided to go with SolarVPS. The VPS was created quickly. I needed a SQL server for small developemntal purposes; So I didn't want to shell out the $10/month extra just yet. I submitted I ticket to them with a copy of my CAL and Product Key:
http://www.nuerom.com/sqlcal.pdf
They sent me a e-mail back saying:
I'm sorry but the document you have attached does not reflect that the software is licensed to you so with this limited information you provided I cannot approve the use of SQL Server 2005 Standard on your VPS.
Well, I sent them the CAL and product key, so what more could they want? The copy of SQL server was recieved from a Microsoft Launch Event, Launch Tour 2005, so I didn't get a invoice. I sent them a copy of the items sent out with:
http://farm1.static.flickr.com/30/61427015_af82ba821b_o.jpg
And opened a chat with them. The chat conversation is attatched:
http://www.nuerom.com/solarvpschat724.txt
In summary,
I asked what they needed to validate - they claimed they needed a invoice.
I didn't understand how a invoice would prove anything, since it is something that can be generated by anyone in a few minutes.
They claimed they get audited from time to time by Microsoft, so they have to make sure genuine software is running on their VPS.
I offered them my MSDNAA license, since I would be only using the server for developmental purposes. I send the a PDF of the MSDNAA order; only to have them deny it again. They claimed that it wasn't valid because I paid with a paypal business account. Even though the MSDNAA terms clearly state that it is a valid license for test and developmental purposes; and that the license is perpetual.
I offered to ship the DVD, CAL and BOX to them. They claimed that this wouldn't be enough to validate. (Implying, of course, that they had some reason to believe I might have stolen the DVD).
At a loss of what to do; I finally contacted Microsoft to have them validate the product; partner support was very nice and directed me to the appropiate departments. I sent solarvps a e-mail back:
I contacted Microsoft and recieved this information. They advised me that the only restriction on this software is that it is NOT FOR RESALE, and that I may put it in full production use. I was told that if you needed validation, you may call 800-426-9400 option 3, option 1. You may reference my name, or my phone number, which will validate my conversation with Microsoft.
See also,
http://download.microsoft.com/documents/useterms/SQL%20Server%20Standard_2005_English_9137cd88-ab33-48b7-ac2a-544f2ec58c4d.pdf
They have yet to reply. I am at a loss of what to do; as I have other promotional software I'd like to install on that VPS; but if its this much of a hassle, I might just go with another host. Unfortunately, solarvps canceled their refund program, so I am at a loss what to do there.
In particular - I feel that SolarVPS just doesn't want to authorize the SQL server because they want me to pay $10/month. This is way too much validation. Besides, as a MS partner, if they were afraid of the software failing auditing they could have called their MS Partner line to verify it was genuine software. Additionally, I felt that Bogdan Fetita, their "senior tech" had attitude that made me feel very unwelcomed.
Should I just move on and find another VPS server after days of trying to find the right one? Or should I hope solarVPS will lighten up?
View 10 Replies
View Related
Jun 17, 2008
My client is looking for a company that can provide managed dedicated servers for use with SQL Server 2k5 and IIS. I believe the client is looking to have everything installed for them and then be handed the keys once complete.
View 3 Replies
View Related
Dec 27, 2007
I`ve just got a new Windows 2003 Web Edition box and now I`m going to install a database server on that.
MSSQL 2005 license would costs 270$/mo for me, So thats not possible to use it because of its price.
I`m not sure if MSSQL Express 2005 or MSDE (which are free) can handle all requirements of ASP.NET programmers or not.
Is there any limitations for major scripts on those? or will those make any doubts for programmers?
Please share your experiences and suggestions.
* I`m going to install "Hosting Controller" on that box.
View 8 Replies
View Related
Nov 20, 2007
I am in search of windows host supporting .net 2.0 and sql 2005 and atleast 2 domains (3 will be good). I need around 3 gb space and 20gb bandwidth is enough. My maximum I have checked the offers section and other posts here and below are the shortlisted hosts:
discountasp
eukhosts
appliedi
exabytes
Can someone who's using them give a suggestion/feedback or else can suggest one?
View 14 Replies
View Related
Mar 8, 2007
I am curious what "methods" Windows providers out there use to deploy Windows Server to Virtual Machines using Virtual Server 2005 when the machine is "remote" at a datacenter.
View 5 Replies
View Related
Jan 2, 2007
how to use my local drive to install sql 2005 on window 2003 server using remote desk top.
The sql 2005 comes in 2 CDs and I need somehow to mount my local drive so I can install it on the server.
I will really appreciate if someone point me to a howto or tell me in details how to do that.
View 1 Replies
View Related
Oct 20, 2009
I am looking for a company to host a relatively simple data driven ASP.Net 3.5 website and a MS SQL 2005 database. There will be minimal traffic on the website as it is for a small business and also minimal media will need to be hosted. Features like Ajax should of course also be enabled.
Data security is of importance although as the developer of the site, I would like the flexibility of being able to configure the database (run scripts) through management studio remotely.
Email features will also eventually be required.
The company should ideally be based in the UK and decent support id (and when) the need arises.
Any recommendations? What sort of price range should I be looking at?
Most companies seem to support MySQL- but this is not flexible.
View 10 Replies
View Related
Apr 4, 2008
I have several gigs worth of data which my programmer wants to put into MS SQL 2005. But the last time I check, MS SQL comes in blocks of only a few MB (eg 200MB for $25).
Now if I have 10GB of data, that yould cost me like...thousands?).
One solution is to use mysql which is free of course, but the website is done in ASP.NET. How will this affect performance?
Also, is there any other way which I can purchase SQL 2005 myself? If yes, how much for one domain name?
View 12 Replies
View Related
Dec 23, 2008
i am finding a MSSQL 2005 server for one of my application for my client.
Actually, it is a small business program. It will not have a heavy load on the server.
Do any hosting packages company for that with reasonable price? It is not a website. It is a C# software application. So the port will not be 21 or some web port.
View 3 Replies
View Related
May 3, 2008
I would like a VPS account, but the problem for me is that my site is asp.net and has a MS SQL 2005 database. From the research I have done so far, it appears that only the shared hosting solutions provide a MS SQL database, and if I go with a VPS solution I have to own and install my own copy of MS SQL. Is this correct? Does anybody know of a VPS solution that would also provide me with a MS SQL 2005 database as well? I can't afford to pay $5000+ for MS SQL 2005 Standard Ed.
View 9 Replies
View Related
May 4, 2007
I am using SQL 2005 Express Management Console in the CTP version, but when I upgrade to the release version, it can't login. Do I need to upgrade the SQL 2005 Express to Service Pack 2 first before it can login? Anyone facing similiar issues?
Secondly is there anyway I can upgrade from SQL 2005 Express to SQL 2005 Express Advance version?
View 2 Replies
View Related
May 11, 2007
Knowing that Port 1433 is one of the most attacked ports, I am thinking whether I should just change the default port of my new MS SQL 2005 installation, but issue is, what will be the disadvantages to users if I do so?
View 4 Replies
View Related
May 10, 2008
I have never upgraded SQL 2005 express edition before thats why a bit worried. What is the safest way to upgrade it to Service Pack 1? Secondly the management console upgrade. Which to upgrade first the SQL or the SQL Express Management console?
View 2 Replies
View Related
Jul 15, 2007
I have to tranfer our user and their Databse to a dediServer. How can i move all/selected user I know how to mmove the database with detach attacj function but how user login can transfer along with their databse. Is it possible using Managmaent studio.
Windows 2003 Enterprise edition
IIS 6.0
Sqlserver2005
View 6 Replies
View Related
Mar 11, 2008
how do you guys do the maintenance for shared hosting SQL 2000/2005? Do you just let the customers do the maintenance, compacting and optimizing themselves or do you scheduled a task to do that?
Till now I had let my clients do that. But some clients it seemed do not really know much about this. But if we were to compact or optimize all the databases by task scheduling, I am worried that it is something against their privacy.
View 2 Replies
View Related
Jun 4, 2008
I've got MSSQL 2005 Enterprise running on Windows 2003 Standard R2 x64. The server has 12GB RAM.
Now, I've been trying to find some way to monitor how much RAM MSSQL takes up, but found two conflicting things.
One source says that MSSQL 2005 Enterprise can only use up to 4GB RAM on Windows Standard R2 x64. Another says Microsoft changed this to 32GB for Windows Standard R2 x64 only (i.e. not x86).
Could anyone confirm either of these? I'd find out myself if I knew how I could see how much it's using (it only shows 90mb in taskmanager).
View 4 Replies
View Related
Aug 9, 2008
Can I upgrade MS SQL 2000 Standard Edition to SQL 2005 Express Edition? I know I can upgrade to SQL 2005 Standard as well as Enterprise Editions, but I want to know if I can also upgrade to the SQL 2005 Express Edition.
View 0 Replies
View Related
Jul 1, 2008
recommend me about a good hosting provider for those requirements: Windows IIS hosting, support for .NET 2.0, MS SQL 2005 Database & ISAPI_Rewrite?
View 4 Replies
View Related
May 8, 2007
I've got a VPS which is serving as the main server for a number of sites. Web Server, SSH Server, and Mail Server.
What I've got running:
Apache2, PHP5, MySQL5, Dovecot, Postfix
One of the sites is a growing forum with a MASSIVE photo album. This is the site where I notice the most slowness.
Changing the server software is not an option - Only optimization.
Quote:
Originally Posted by httpd.conf
ServerTokens OS
ServerRoot "/etc/httpd"
PidFile run/httpd.pid
Timeout 300
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
StartServers 8
MinSpareServers 8
MaxSpareServers 13
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 50
</IfModule>
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
Listen 80
LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule auth_digest_module modules/mod_auth_digest.so
LoadModule authn_file_module modules/mod_authn_file.so
LoadModule authn_alias_module modules/mod_authn_alias.so
LoadModule authn_anon_module modules/mod_authn_anon.so
LoadModule authn_dbm_module modules/mod_authn_dbm.so
LoadModule authn_default_module modules/mod_authn_default.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule authz_owner_module modules/mod_authz_owner.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_dbm_module modules/mod_authz_dbm.so
LoadModule authz_default_module modules/mod_authz_default.so
LoadModule ldap_module modules/mod_ldap.so
LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
LoadModule include_module modules/mod_include.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule logio_module modules/mod_logio.so
LoadModule env_module modules/mod_env.so
LoadModule ext_filter_module modules/mod_ext_filter.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule expires_module modules/mod_expires.so
LoadModule deflate_module modules/mod_deflate.so
LoadModule headers_module modules/mod_headers.so
LoadModule usertrack_module modules/mod_usertrack.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule mime_module modules/mod_mime.so
LoadModule dav_module modules/mod_dav.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule info_module modules/mod_info.so
LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule vhost_alias_module modules/mod_vhost_alias.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule actions_module modules/mod_actions.so
LoadModule speling_module modules/mod_speling.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule cache_module modules/mod_cache.so
LoadModule suexec_module modules/mod_suexec.so
LoadModule disk_cache_module modules/mod_disk_cache.so
LoadModule file_cache_module modules/mod_file_cache.so
LoadModule mem_cache_module modules/mod_mem_cache.so
LoadModule cgi_module modules/mod_cgi.so
Include conf.d/*.conf
User apache
Group apache
Quote:
Originally Posted by my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
View 8 Replies
View Related
Mar 7, 2009
I looked a lot - can not find solution ....
I want to transfer a file from [url]to [url]or [url]Without it will pass my localcomputer (slow upload)
It can be also a script i will install like this one - this is only for images
[url](remote)
View 7 Replies
View Related
